tallgaluser
Technical User
How can I create a macro that will kick off queries one after the other. As each query runs it appeneds the data to a table.
Thanks
Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Macros
- Thread starter tallgaluser
- Start date
- Status
RandyMyers
IS-IT--Management
Just use the macro command OpenQuery. You can then run another OpenQuery, etc.
If you do not want to be prompted on the append query then use the command SetWarnings, off before running the first OpenQuery command. Just remember to re-run SetWarnings and set to On after the last to insure that warnings are turned back on.
If you do not want to be prompted on the append query then use the command SetWarnings, off before running the first OpenQuery command. Just remember to re-run SetWarnings and set to On after the last to insure that warnings are turned back on.
- Status
Similar threads
- Locked
- Question
- Locked
- Question