Turning off Confirmation of record changes/Action queries etc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to edit (individually would be good) or turn off completely the
confirmation messages when i run a query or alter records in my database so
that anybody running the database from a different machine will not
constantly have to click yes/ok all the time.

I can do this for my individual location through
Tools/Options/"Edit/Find"/Confirm but i want greater control over this.

For example i have a Macro that runs 4 Append/Delete queries and i want one
popup that i can input what it says with an ok/cancel chocie) but not all the
others
 
You can use the SetWarnings line in your macro with the properties False to
turn off messages and True to turn on the confirmation messages.
i.e.
SetWarnings
Append/Delete query 1
Append/Delete query 2
etc.
SetWarnings

In the first SetWarnings, make the property False (Switch off) and in the
second make the property True (switch back on)
 
That works for me

But can i attach my own dialogue box to the Macro (m own warning text and
ok/cancel buttons). Or does that HAVE to be done through the button on the
form it will run from.

Thanks for the help
 
You are better off doing it from the form as you suggest, so that you are in
control of what you say in the message, the buttons that can be pressed and
when to run your macro without the messages.
 
Back
Top