Conditional action after a MsgBox

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

Guest

I am writing a long Macro that will action a number of append and delete
Queries. I want to start with a warning in a MsgBox explaining the
consequences, then allow the user to select OK to continue the Macro or
Cancel to end the macro at this point, but I'm afraid I can't see how to do
it.

Any help would be much appriecated.
 
Have your macro call a small form that has your message and a checkbox to
continue and another to stop.
Then have condition --
[Forms]![YourMessageForm]![YourCheckBoxContinue] = 0
Have action Close YourMessageForm
Then have condition --
[Forms]![YourMessageForm]![YourCheckBoxContinue] = 0
StopMacro.
Have action Close YourMessageForm
 
Hello Glen.

Glen B said:
I am writing a long Macro that will action a number of append and
delete Queries. I want to start with a warning in a MsgBox explaining
the consequences, then allow the user to select OK to continue the
Macro or Cancel to end the macro at this point, but I'm afraid I can't
see how to do it.

Any help would be much appriecated.
Click to expand...

At the beginning choose the StopMacro action with a condition like this:
(Use the view menu to display the conditions column)
MsgBox("Dear user...", 305, "Warning!") <> 1

Explanation: See onlone help for the MsgBox function.
 
Igot in a hurrry and did notr edit after pasting --
Have your macro call a small form that has your message and a checkbox to
continue and another to stop.

Then have condition --
[Forms]![YourMessageForm]![YourCheckBoxContinue] = -1
Have action Close YourMessageForm

Then have condition --
[Forms]![YourMessageForm]![YourCheckBoxStop] = -1
Have action Close YourMessageForm

Then have condition --
[Forms]![YourMessageForm]![YourCheckBoxStop] = -1
Have action StopMacro.




KARL DEWEY said:
Have your macro call a small form that has your message and a checkbox to
continue and another to stop.
Then have condition --
[Forms]![YourMessageForm]![YourCheckBoxContinue] = 0
Have action Close YourMessageForm
Then have condition --
[Forms]![YourMessageForm]![YourCheckBoxContinue] = 0
StopMacro.
Have action Close YourMessageForm

Glen B said:
I am writing a long Macro that will action a number of append and delete
Queries. I want to start with a warning in a MsgBox explaining the
consequences, then allow the user to select OK to continue the Macro or
Cancel to end the macro at this point, but I'm afraid I can't see how to do
it.

Any help would be much appriecated.
Click to expand...
Click to expand...
 
Back
Top