CreateQueries5.mdb (expert)

Please consider donating $1 per sample downloaded, find out why here
Access 97 (96 KB)

This set of samples illustrate how to create a flexible query generator for your users. It is similar to CreateQueries4.mdb, but no longer limits the query to 3 criteria.

Because the information for the criteria is stored in a table, there are multi-user considerations. If you use the Singe-User edition in a multi-user environment, users will be over-writing each other's queries. Therefore the Multi-User Edition creates a temporary database on the user's C: drive to store the Where Criteria.

The Basic query generator shows just the basics of getting the unlimited Where Clause to work.

The Advanced query generator allows you to choose a table or a query for the FROM clause, allows you to select which fields to show in the Field List, and allows parentheses in the Where clause.

To use: Each form is self-contained with all the code needed. Just copy the form you want and the two tables: CriteriaTable and TableFields into your application.




Need Winzip?

Return to Main Page