Surpress Update Confirmation

  • Thread starter Richard Albrecht
  • Start date
R

Richard Albrecht

Hi,

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

TIA

Rich
 
P

Phobos

DoCmd.SetWarnings = False

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

P
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ECHO OFF applying to MULTIPLE Macros or MODULES! 1
Supress Confirmation Prompt 1
Surpress Confirmation Messages while updating records with VBA 3
Hiding Zeros 2
surpress confirmations 2
Sometimes the XP window goes to full screen when I just want to move it. 2
How to stop duplicates in a query or report 3
surpress leading and trail spaces 2

Top