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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append record to another table 4
Appending all records 3
Hide "You are about to" message box 1
Access Macro Repeat Expression using value of a field in table 0
Invoice Append 1
DoCmd.RunSQL Question 2
Using for to append modified records to new table 4
Append Query Issue 0

Back
Top