disable confirm record changes and action queries

[priac]

I have a program that performs a number of updates and queries when each form is closed. I have "confirm record changes and queries" turned off in the options, but some of the people using the program don't. When it ask if they want to update a table they are unsure of what to do. Is there a way to turn this off when they enter the program and back on when they exit?

Aubrey Price

 

[lewatkin]

In AutoExec macro, SetWarnings False. Or use the Autoexec macro to run the same thing in code.

OnClose event - SetWarnings True

I don't think I would disable the warnings during the whole time the user is in the database though. I prefer to disable them at runtime for that action.

Others here may (probably) have different view points though.

Lee

 

[B827]

I use code to set the warnings off run the query and set the warnings back on. The error handling also sets the warnings back on again. As Lee says it is not good to have the warnings set off for any longer than the minimum required by the operation.
Sandy