Turning off Confirmation of record changes/Action queries etc

[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

 

[Guest]

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)

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

Here is an alternate method for your consideration:

http://groups.google.com/group/micr...e_frm/thread/7684cb1f5e97115/b5ab65bc92dc812f

Notes:
1.) To see the original question, click on "Show quoted text" at the bottom
of the first message shown.

2.) Ignore the "contribution" from our resident troll (aaron).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________