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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Mike" <(E-Mail Removed)> wrote in message
news:1492376E-A37C-450D-A56B-(E-Mail Removed)...
> 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