Theodore- It would help if you included the previous message string in your replies ... <s>
As I recall, you're doing DoCmd.RunSQL. Instead, do: db.Execute strSQL, dbFailOnError 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 tyki9799 > Sent: Thursday, June 23, 2005 8:32 AM > To: [email protected] > Subject: [ms_access] Re: Moving records between tables > > > Hi John! I'm really sooooo GRATEFUL. IT WORKS at last! I had to delete > 2 parentheses and there it was done! One last issue: could I get rid > of the "You are about to append # records..." message? > > The last thing left to do is to write the two DELETE queries. > > Thanks again, > > Theodore > > > > > > Yahoo! Groups Links > > > > > 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/
