Thank you! 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.
-----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rogers Beasimer Sent: Monday, October 03, 2005 3:32 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Appending Records Modify your last line to include the second closing parenthesis (it goes the with one after the word "execute"). Also you need to enclose your actual text string in single quotes. db.Execute ("INSERT INTO tblContactDetails VALUES(" & results!lngClientID & ",'2005EL')") ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
