Search for a duplicate person before adding

[bluegrassstateworker]

I am trying to locate some VBA code for Access that will perform a
soundex-type search on the name and return a list of potentials where
the user can visually scan that list to determine whether to add a new
record.

My fields to use are: FNAME, LNAME, Address, City, State, Zip, County,
phone number. What I do not have is a field truely unique that would
make everything so simple.

My thought is to have a first and last name available for entry. Once
entered, a search is performed and the results displayed which
contains field information sufficient to determine if the person
exists in the list already or not. Data collection for this database
will be inconsistent; the person entering data may only have a first
and last name and will need to somehow determine whether the person
they wish to enter already exists. There should be a county and city
available but that is not 100%

Surely there is an existing routine for doing this type of search
efficiently either on the web or in a book. I am using Access 2003.
Any assistance in directing me appreciated.

 

[Douglas J. Steele]

I gave an implementation of Soundex in my April, 2005 "Access Answers"
column in Pinnacle Publication's "Smart Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[bluegrassstateworker]

I gave an implementation of Soundex in my April, 2005 "Access Answers"
column in Pinnacle Publication's "Smart Access".

You can download the column (and sample database) for free athttp://www.accessmvp.com/DJSteele/SmartAccess.html

Thanks Doug I will look at it.
Regards, Andy

 

[Tony Toews [MVP]]

My fields to use are: FNAME, LNAME, Address, City, State, Zip, County,
phone number. What I do not have is a field truely unique that would
make everything so simple.

I had a list of 10,000 names. It was surprising how the first two
letters of the first name and the last name whittled down the list to
only four or five people. Including the classic "jo" and "sm"

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/