Append message question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get the "You are about to append one record" when running my SQL. I forgot how to bypass this message and go ahead and append the record.

Thanks
Mark
 
One way is to run DoCmd.SetWarnings False before you run the SQL (then
DoCmd.SetWarnings True once the SQL has run).

A better way, in my opinion though, is to use the Execute method of either
the Database or QueryDef object. The reason I prefer this is that you can
specify an option of dbFailOnError, so that you can trap any errors that may
occur.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



mark said:
I get the "You are about to append one record" when running my SQL. I
Click to expand...
forgot how to bypass this message and go ahead and append the record.
 
Back
Top