 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / March 2007RunCommand question
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. > 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! 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.  SignatureSteve Schapel, Microsoft Access MVP > 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! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.