Print Page | Close Window

RunProcessesAndExport

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=611
Printed Date: 23 Oct 2017 at 3:49am


Topic: RunProcessesAndExport
Posted By: Roger Carlson
Subject: RunProcessesAndExport
Date 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: uploads/5/RunProcessesAndExport.zip - RunProcessesAndExport.zip

-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window