Thanks John, There's alot of nice code in there to look at! 2 questions... 1. I get a compile error on the ISNothing statement, am I missing a file? 2. Is there a way to show a list of possible duplicates?
Thanks Joe --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Joe- > > Check out the BeforeUpdate event in frmContacts in this sample database: > > ftp://ftp.viescas.com/Download/Contacts2000.zip > > It performs a check for possible duplicate name using SoundEx. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of eliotchs > Sent: Thursday, December 08, 2005 9:17 AM > To: [email protected] > Subject: [ms_access] ? on Checking Duplicates.. > > Hi, > > I'm looking for some samples for checking for duplicates. > I have an SSN field set to be unique, but sometimes do not get the SSN > I'd like to setup a listbox for show up with client of the same name so > users cab check to see if they are the same person they are trying to > enter.. > > Thanks In advance > Joe > > > > > > > > > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
