CREATING AN EXPORT DIALOG TO EXPORT AN APPLICATION'S TABLES

Many times, it's a good idea to give users—or at least the administrator—an option for exporting tables. The point is to allow them to do so without the hassle of having them get to the database container.

To take this a step further, how about giving users the choice of exporting to various file formats? Sometimes it can be a challenge to give users the flexibility they need with the control that's necessary.

Looking at What the Export Utility Demonstrates

The ap_SystemUtilities form can export various tables in the applications. Figure 28.1 shows this form with multiple tables selected to export.

Figure 28.1. This utility form allows you to export multiple tables.

This example of exporting ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.