Microsoft Office Tutorials and References
In Depth Information
Access Procedures
Access Procedures
By Nico Altink
Splitting Names
This procedure demonstrates how to separate the different parts of a name in a
field using a supporting form.
Example file:
A005.mdb with
frmSplitNames
Scenario: Some files may contain names that incorporate
unlike data, making it difficult to parse data appropriately.
Such is the case with the titles in the data shown below.
Extracting them properly requires VBA, where other text
extractions may not. What to do when titles exist (perhaps
even two titles!) is now presented.
To split strings of text based on a selected portion of the field, use the form
‘frmSplitNames’ with some code. The table looks like Figure 78:
Acs
Figure 78- Table Behind frmSplitNames
The desired format is to split the names as shown below:
Titles
Initials
MiddlePart
LastName
ir.
Y.H.M.
van de
Ven
G.W.M.
Smeets
 
Search JabSto ::




Custom Search