supressing cofirmations on update queries

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

Hello All,

(Access 2000)


Is there a way to turn off the default confirmations when using a update
query?

I don't want to be prompted for anything when I run this update query, but
can't figure out how to turn off those darn confirmations.

TIA,
_Bigred
 
Do you mean running the Query by the GUI or VBA code?

For the GUI, use the Menu Tools / Options ... / Edit_Find tab / Confirm pane
and uncheck the Action Queries. However, I would advise *against* it. You
or someone can run a Query:

DELETE * FROM YourTable

and *all* Records will be deleted.

For VBA code, use:

DoCmd.SetWarnings False
'Code to run your Query
DoCmd.SetWarnings True

Alternatively, you can use:

CurrentDB.Execute strSQL, dbFailOnError

and the Execute Method does not require confirmation.
 
Back
Top