I am having a Brain Cramp. I have a string containing a full name such as "John Smith". How can I break that up in VBA, so that I can get FirstName = "John" and SecondName = "Smith".

Thanks in advance

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Not to worry, my brain has uncramped.

If you use the Split function, it will load the various parts of the String into an array. The tricky part is that there is an occasional Middle Initial, so I am going to initialize the array with 3 elements and then check to see if the third is blank, and if so assume that there is only a first and last name.

Thanks for looking at this anyway - and Merry Christmas!!

Mike
EchoVue.com

I have used split to split arrays that have as many as five members, and sometimes only the first two have data. I check the array for nulls and then concatenate the string based on the nulls (leaving them out of course.)

Hope the cramps go away.



mmcdonal

Well, the cramps went, but now they are back.

Here is an interesting problem. I am building a SQL string dynamically to retrieve the PK of a user name from a master names table. It works great until the users name is something like O'Brien or O'Donnell.

How can I get the following string to work if userName = "O'Brien"

SQL = "SELECT nam_PK from M_Names WHERE nam_Name = '" & userName & "'"



Mike
EchoVue.com

Not to worry again,

I used chr(34) instead of the '. Hopefully my users will not use " in any of their data!!

Thanks

Mike
EchoVue.com