RE: [AccessDevelopers] Appending Records

[Crosier, Dawn]

Thanks!  Working now!    Dawn Crosier Application Specialist "Education Lasts a Lifetime"   This message was posted to a newsgroup.  Please post replies and questions to the group so that others can learn as well.   From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly Sent: Monday, October 03, 2005 3:37 PM To: AccessDevelopers@yahoogroups.com Subject: Re: [AccessDevelopers] Appending Records I forgot to put in a closing )  I have one to close the VALUES() but not to close the Execute()   Also, put single quotes around your string that you are inputting:   db.Execute ("INSERT INTO tblContactDetails VALUES(" & results!lngClientID &", '2005EL')")   HTH, Toby Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.