Duplicate Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which contains contact information for individuals. The fields
in the table are Nbr, Name, Address1, Address2, City, State, Zip, Zip+4,
Phone_Nbr, Fax_Nbr, and Email. On the form, there is a combo box which
contains the Name for the users to select, and if they enter a name which is
not in the combo box it automatically ask if they would like to enter the
information for a new contact. Most of the time they just enter the
information under the name they have now entered. The problem is now we have
multiple entries for the same name because of misspellings, enter the contact
with the last name first, or a number of other ways using abbreviations. Can
anyone help with a solution on how to clear up this table? I am already
developing a way to stop additional entries from happening like this. Thanks
in advance.
 
Are we talking < 500 records, or thousands? If only a few hundred, probably
easiest to just sort them by last name and manually review. If thousands,
better to use a name parsing routine. Most of those won't forgive
misspellings, though. You'll still end up with duplicates.

Best way we've found is to standardize all of the addresses then match the
records by address. You can then compare only the multiple names at the same
address. www.zipinfo.com (what we use) offers a fairly reasonable SDK that
includes the necessary databases and example Access code. Also, once you
have it, you can standardize each address as it's entered.

Bruce
 
I have a table which contains contact information for individuals. The fields
in the table are Nbr, Name, Address1, Address2, City, State, Zip, Zip+4,
Phone_Nbr, Fax_Nbr, and Email. On the form, there is a combo box which
contains the Name for the users to select, and if they enter a name which is
not in the combo box it automatically ask if they would like to enter the
information for a new contact. Most of the time they just enter the
information under the name they have now entered. The problem is now we have
multiple entries for the same name because of misspellings, enter the contact
with the last name first, or a number of other ways using abbreviations. Can
anyone help with a solution on how to clear up this table? I am already
developing a way to stop additional entries from happening like this. Thanks
in advance.
Click to expand...

In addition to BruceS's reply, Name is a reserved Access/VBA/Jet word
and should not be used as a field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
 
Back
Top