I would like to create a macro that will run several make
table queries at the same time and then assign macro to
button for easy execution
Why? Could you explain the context?
In practice, MakeTable queries are VERY rarely necessary or
appropriate.
To answer your question (though I'd prefer to be a Zen master and
"unask" it), call a Macro from the Click event of a button; each line
of the macro should be a RunQuery action running the query. You may
want to put
Setwarnings False
as the first line of the macro, and
Setwarnings True
as the last to avoid repetitive confirmation messages.
But again - You almost certainly DO NOT NEED THIS MACRO; there is very
likely a much better way to accomplish what you're trying to do!
