RunProcessesAndExport |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 14 May 2013 at 7:04am |
This sample illustrates a flexible way to automate the batch processing of queries.
Any query whose name does not start with x, ~, z, or 'Copy of' automatically appears in the All Queries list. Buttons allow the queries to be moved to the Process list or the Export list. When it is moved to either list, it disappears from the All Queries list. The Process List is usually composed of Action Queries. When running the Process list queries, the user is given the option to see Warning or not. Clicking the Process button executes the Action Queries in the list. The Export List is usually composed of Select Queries that need to be exported to either CSV or Excel format. In RunProcessesAndExport.mdb, the queries are exported individually. In RunProcessesAndExportUnion.mdb, the queries are UNIONed together before exporting. Because of this, all the queries MUST have the same number of output fields. To use the sample in your own application, simply import ALL objects in the sample to your database. If you like, you can Hide these objects to keep from cluttering your Navigation Pane. You can find the sample here: RunProcessesAndExport.zip |
|
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |