Joe- A Unique index should take care of it, but I recommend you add a Form Error event procedure, trap error number 3022, and display a more "user friendly" error message.
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: Tuesday, December 13, 2005 2:32 PM To: [email protected] Subject: [ms_access] Re: New file uploaded to ms_access Hi John, That now works great! Do you suggest I right a routine to check dup SSN Numbers? Right now I just have the No dup option on. Also, (I know I'm pushing it..) Cna you give me some ideas on how to put up a listbox instead of the msgbox so if someone chooses an existing client it will open the same form with that clients info. Thanks in Advance Again!! Joe --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Soundex is bombing when you try to pass it a Null last name. Change the > code to: > > Set rst = CurrentDb.OpenRecordset("SELECT LastName, FirstName FROM " & _ > "client WHERE Soundex(NZ([LastName], ' ')) = '" & _ > Soundex(Me.LastName) & "'") > > You also have a problem that the form always thinks it's "dirty", so you get > an error on the required SSN number when you try to clear and close the > form. > > 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] > Sent: Tuesday, December 13, 2005 9:13 AM > To: [email protected] > Subject: [ms_access] New file uploaded to ms_access > > > Hello, > > This email message is a notification to let you know that > a file has been uploaded to the Files area of the ms_access > group. > > File : /clientdb.ZIP > Uploaded by : eliotchs <[EMAIL PROTECTED]> > Description : Client Db for John V to check > > You can access this file at the URL: > http://groups.yahoo.com/group/ms_access/files/clientdb.ZIP > > To learn more about file sharing for your group, please visit: > http://help.yahoo.com/help/us/groups/files > > Regards, > > eliotchs <[EMAIL PROTECTED]> > > > > > > > > > > > Yahoo! Groups Links > Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/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/
