Dismiss a dialog box

[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.

 

[tina]

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

 

[Steve Schapel]

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!

 

[tina]

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.