Help needed with comparing First/Last Name combinations

  • Thread starter Thread starter John Moore
  • Start date Start date
J

John Moore

Does anyone know of or have any VBA code or similar logic that can
help distinguish similar first/last name combinations? For example, we
would like to prompt the user of a possible match when any of the
first/last names Robert Smith, or Bob Smith, or Robt. Smith are used
during data entry. All that is necessary is to alert the user so that
they can review any appropriate existing records.

We have done several google searches without any luck. Any and all
help is appreciated.

TC
 
What about
--Robert Smyth
--Bob Smithe

Assumption, you have the two parts of the name in separate fields.

You can use Soundex code to get similar sounding names. Google for soundex
in the access modulescoding group.

For things like Robt = Bob = Robert or John = Jonathan = Jack or Susan = Sue
= Susanne = Suzanne, you will probably have to build a table of equivalents
(aliases) and use that.

I have a little mailing list program that shows suspected dupes based on the
first two letters of the first name and matching last names or first two
letters of first name and the matching soundex of the last names (users can
specify the "sensitivity" of the search. But even that wouldn't catch Bob
being equal to Robert.
 
Perhaps if there is another field to add to the compare, such as phone or
address... Interesting problem!
 
John Moore said:
Does anyone know of or have any VBA code or similar logic that can
help distinguish similar first/last name combinations? For example, we
would like to prompt the user of a possible match when any of the
first/last names Robert Smith, or Bob Smith, or Robt. Smith are used
during data entry. All that is necessary is to alert the user so that
they can review any appropriate existing records.

We have done several google searches without any luck. Any and all
help is appreciated.

TC
Click to expand...


=====================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM: http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net
==========================================================
 
Back
Top