Skip confirmation dialog for append query

[Andreas]

I call an append query from a form using code:
DoCmd.OpenQuery "Quotation-to-Invoice Query", , acAdd

How can I skip the 2 confirmation dialogs that follow? (only for this
execution, not globally)

 

[Allen Browne]

One approach is to turn off SetWarnings, but then you don't know if it
succeeded or failed or how many records were affected.

It's better to use the Execute method. Details in:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html