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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-19-2013, 10:28 AM   #1
mresann
Newly Registered User
 
mresann's Avatar
 
Join Date: Jan 2005
Location: Long Beach CA
Posts: 336
Thanks: 2
Thanked 1 Time in 1 Post
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, 267 views)

mresann is offline   Reply With Quote
Reply

Tags
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 06:34 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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