Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - RunProcessesAndExport
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

RunProcessesAndExport

 Post Reply Post Reply
Author
Message
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Status: Offline
Points: 249
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: RunProcessesAndExport
    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
Consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down