Dismiss a dialog box

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

Guest

When using a macro that includes a command to run a make-table query, is
there a way to stop the dialog box that asks to confirm the make-table
action? The user says activating the macro, in their mind, confirms the
action and the user is already into something else when the dialog box
appears.
 
in the macro, use the SetWarnings action before and after the OpenQuery
action. first action, use No in the action argument; last action, use Yes in
the action argument. suggest you read up on the SetWarnings topic in Help,
so you'll understand how it works.

hth
 
Well, actually there is no need to use a SetWarnings/Yes action at the
end, as the Warnings automatically reverts at the end of the macro anyway.

But that's just me being pedantic, I suppose. :-) Does no harm either!
 
yes, i did know that, but i'm always wary of who may read the post, now or
in the future, and how they might use the idea elsewhere - in VBA, for
instance, where the second SetWarnings action *is* necessary to restore the
status quo. since the action does no harm in the macro, as you noted, i'd
rather play it safe. ;)
 
Back
Top