Skip confirmation dialog for append query

  • Thread starter Thread starter Andreas
  • Start date Start date
A

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