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.
 
Back
Top