Viewing 12 posts - 31 through 42 (of 42 total)
like2innovate (2/22/2010)
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 23, 2010 at 4:50 pm
Hi like2innovate,
As far as books go, I definitely recommend "Microsoft SQL Server 2008 T-SQL Fundamentals" by Itzik Ben-Gan. You'll need to understand how to write - and at the...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 23, 2010 at 4:31 pm
Hi sqlserver12345,
Are you sure that you're not losing the first character from the forename (FirstName field) as opposed to the surname (LastName field)? It'd be easy to get mixed up,...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 23, 2010 at 3:43 pm
Cheers grovelli! 🙂
I thought I'd worked out how to use the formatting on the board, but I've just copied the code from the message into a module and it ended...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 23, 2010 at 12:07 pm
I'm probably not the first person to have had some bad Ikea-experiences, but the benefit of them has been that I've learnt the hard way that I should always read...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 21, 2010 at 4:45 pm
Hi keywestfl9,
If you haven't already, then consider having a look at the SSMA (SQL Server Migration Assistant) for SQL Server 2005. I've only had the opportunity to use the...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 19, 2010 at 8:47 pm
Hi brandonmooreis,
I'm moving up to SQL Server from MS Access, so posts like yours really help me in realising the potential pitfalls I might have to face.
I can't offer...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 19, 2010 at 8:14 pm
Hi GSquared,
The "Select Case When Exists..." query in T-SQL is lovely and it holds a special place in my heart. It's absent from MS Access's SQL, but I...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 19, 2010 at 7:17 pm
Hi Frances L,
As metra-905617 rightly says, you need to find the first instance of a space and then take the characters before it to get the forename or initial, but...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 19, 2010 at 4:17 pm
I've only just noticed you originally asked:
I'm trying to enter a numeric value in a text box. eg. client Id,
There's a really important function in VBA called "IsNumeric"; you pass...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 18, 2010 at 7:13 pm
Hi All,
Before replying to my above post please read this apology for answering a non-SQL Server related question!
These are my first two posts, and I couldn't find a specific board...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 18, 2010 at 4:48 pm
Hi Ritesh,
This really isn't a forum for MS Access VBA questions, and there's lots of more specialised forums that you should use that will be able to help you. ...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
February 18, 2010 at 4:41 pm
Viewing 12 posts - 31 through 42 (of 42 total)