RunCommand question

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

Guest

This is probably really basic, but in my macro is it necessary to have
OpenQuery before I tell it to RunCommand/Run ? I'm trying to set a macro to
run my make-table query, but if I can avoid having to open the query itself
first I can save about 15 minutes. Am I even using the correct set of
actions? Help!
 
the OpenQuery action in a macro is running or designing.
Make sure the view is set to Datasheet.
 
Lisa,

If it's a Make-Table Query, you can't "open" it. Using an OpenQuery
macro action for an Action Query such as Make-Table will cause it to Run.

As for the comment about 15 minutes, well, that's a mighty big query! I
would guess there might be ways to make it more efficient.
 
Back
Top