Hi John,
I think, I'm stuck in a loop..
I added the module, and changed the line:
Set rst = CurrentDb.OpenRecordset("SELECT LastName, FirstName FROM "
& _"client WHERE Soundex([LastName]) = '" & _
Soundex(Me.LastName) & "'")
'client is the name of the table
'lastname and firstname are the names of the fields on my form also.
It runs, but I get the hourglass neverending?
Joe
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote:
>
> Joe-
>
> 1. You need the modUtility module from my database - that contains
the
> IsNothing custom function.
>
> 2. Note that the sample code in the form BeforeUpdate event
assembles a list
> of possible duplicate names into a string variable and then
displays the
> list using MsgBox. You could also use the SQL in the search query
as the
> Row Source of a List Box or the Record Source of a Continuous Form
to
> display the list of potential duplicates.
>
> 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: Friday, December 09, 2005 12:11 PM
> To: [email protected]
> Subject: [ms_access] Re: ? on Checking Duplicates..
>
> 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 Links
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
AIDS in India: A "lurking bomb." Click and help stop AIDS now.
http://us.click.yahoo.com/9QUssC/lzNLAA/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/
