Create macro that will run one or several make table queries

  • Thread starter Thread starter Charlie Helfrich
  • Start date Start date
C

Charlie Helfrich

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
 
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
Click to expand...

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!
 
Back
Top