Go Back   Access World Forums > Microsoft Access Reference > Microsoft Access Tutorials

Thread Tools Rate Thread Display Modes
Old 07-19-2013, 10:28 AM   #1
Newly Registered User
mresann's Avatar
Join Date: Jan 2005
Location: Long Beach CA
Posts: 347
Thanks: 3
Thanked 3 Times in 3 Posts
mresann is on a distinguished road
Talking Automate processing of Western Names

Perhaps the most fundamental reason for using a database is to process names. Specifically, a process that can automatically parse a name into its constituent name parts and provide a method in which names can be populated into their proper places is a great time-saver.

For instance, if you type the name "Mr. John Q. Smith, Jr.", the process would automatically parse out the name as such:

Prefix: Mr.
First Name: John
Middle Name: Q.
Last Name: Smith
Suffix: Jr.

Of course, the process should be able to determine prefixes, suffixes, names with prefix surnames in which the last name consists of more than one name part (such as "Oscar de la Hoya"), and even nicknames if they are wrapped in double quotes.

The tutorial includes a complete database, a detailed instruction Word document, and the procedure that handles the automated process is richly commented, allowing the programmer to understand the logic.

After a programmer is familiar with the process, it is a simple matter to import the tables, query, and module into his own development arena and modify it to his own needs.

The contents of the zip file are a word document and an access database. Of course, you must require macros and/or set Macros to low for the vba to work (but you all knew that already ).

NOTE: Although the database is in the form of .mdb, and was saved as a 2000-2003 database, it was designed in 2013 and I wasn't able to test it on a legacy db. If there are problems with a legacy Access DB, please let me know.
Attached Files
File Type: zip Namedb.zip (332.8 KB, 286 views)

mresann is offline   Reply With Quote

database , names , tutorial , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
hi from western ma. moke123 Introduce Yourself 0 01-11-2013 03:22 PM
Hi from Perth, Western Australia :) Lones78 Introduce Yourself 0 10-24-2012 05:30 PM
New Forum Member From Western Australia frankvel2005 Introduce Yourself 1 09-18-2011 04:56 PM
How to automate renaming field names ppataki Tables 3 06-04-2009 11:17 AM
Non-Western European Version knowledge76 General 0 02-16-2005 12:40 AM

All times are GMT -8. The time now is 02:33 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World