|Please consider donating $1 per sample downloaded, (find out why here)|
Joined: 20 Feb 2008
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
|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