Surpress Update Confirmation

  • Thread starter Thread starter Richard Albrecht
  • Start date Start date
R

Richard Albrecht

Hi,

Is there a way to surpress programatically the update confirmation when
doing an update query?

TIA

Rich
 
DoCmd.SetWarnings = False

Remember to set them back on again once your queries have finished.

P
 
Do you mean in VBA code or through the GUI?

If you meant by code:

DoCmd.SetWarnings False
DoCmd.OpenQuery ...
DoCmd.SetWarnings True

Alternatively, you can use the Execute Method to run your Query and the
Execute Method does not require confirmation.
 
Back
Top