Append row message

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

Guest

How can i turn off the message that appears to Append rowns "you are about to
append (1) rows" so that it does it without asking?

Many thanks
 
DoCmd.SetWarnings False before you run the Append, and DoCmd.SetWarnings
True afterwards.

Alternative, you can use the Execute method of either the Database or
QueryDef objects.
 

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 Query Issue 0
Append Messages 1
duplicate values stoping ALL appends 3
Count no of rows appended 4
Import - Only data that has changed 1
Help please - determine the number of records appended 1
return primary key for record after append query 3
Apply Sequence Number in Append Query 2

Back
Top