Update Query - suppress user prompt to update via macro

[kwagner1]

Using an Access module, I want to execute approx 75 update queries. I need a way to suppress the alert prompt Access gives the user on each update query. I know there is a way under the "Tools -> Options" menu in MS-Access to "Turn confirmation messages on or off" but how would i do it via VB code in a module?

anyone know some simple VB code to do this?
thanks!

 

[Joe4]

In VBA, you turn off these warning boxes with the following command:
DoCmd.SetWarnings False

To turn them back on again, simply use:
DoCmd.SetWarnings True

 

[kwagner1]

Perfect.... thanks!