Recent content by Leeman

Hi JAL. I figured out how to overcome this error by using a count loop that limited to 4 so if there was no salutation then it would go to the next record if it reached the maximum of "other" columns which is limited to 4. Your assistence was excellent, thank you very much Regards Lee

Actually, I just got this working myself :) Do Until rs.EOF Dim pos As Long If rs("Fullname") = "" Then GoTo NextRow pos = InStr(rs("Fullname"), "/") rs.Edit If pos = 0 Then rs("Surname") = rs("Fullname")...

IF ELSE Statements issue and ISNULL statements I have a piece of code which looks for a delimeter "/" in a string (e.g. Smith/John) and if it find the "/" then it splits these two strings at the "/" If the delimiter is not found then the it goes to the next record. however i dont want it to do...

JAL, yes this works fine, and as you correctly mentioned there was an error with a name who had no salutation. If there is the case for no salutation, then what code should I enter to avoid this issue. i am assuming it goes in this part word = words(i) If i = 0 Then...

Thanks Jal, I fixed the bug and it works fine. If there exists any other chars or strings after the salutation how best to ignore these. For example if remnant = Bob J Dr (loc) how to ignore the (loc) remnant = Mid(rs("Passenger name"), pos + 1) words =...

Awesome Access programmer.!!

Yes this works extremly well thank you Jal. One final question. In the orginal column Fullname, is it possible to keep the orginal field contents as they are, because now there is a space between the surname and other names. i.e in field Fullname Smith John C Mr should be kept as...

If the slashes are replaced with a space then a person with a surname with a space in it would be incorrect. So the first step should be Split the column at the slash and create a new column for the surname. Then perform the split with spaces ojn the remaining string, i.e after the slash.

The issues with replacing the slashes with spaces before creating the columns is that a persons surname could be split accross two columns when it should only be the string before the "/"

I agree it will need to be done in two steps. First to split the surname using a "/" delimeter and placing this INTO a new column The second step to seperate the other names using the " ". There would not be more than 5 columns for the names. The Salutation is always at the end the name...

Thanks. The replace option sounds like a good idea except there are some surnames with space in them also. A person may have or not have a salutation. the table is based on user entries and some dont include their salutation.

This is my first post here :). I will try to remember all the sticky points i have just read for noobies. I am new to Access. I am using Access 2007. Problem: I need some assistance in developing a module/procedure that will seperate a single column from a table based on different delimeters...