Append row message

M

Mike

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
 
D

Douglas J. Steele

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