It is often helpful to provide the user a subset of current queries and reports available in a database, and allow that user to edit, run, and export the results. This avoids the need to acquaint the user with all the potential pitfalls of using the database navigation and administrative tools.
This example provides a form that contains two lists; one for queries, the other for reports. To exclude queries and reports that should not be available to the user, I am using a simple naming convention … if the first letter is a tilde (~), it will not be made available to the user. To populate these lists, this example includes 2 queries; one that returns all queries that do not begin with a tilde, the other all reports that also do not begin with a tilde.
The user selects an item from one of the lists. Buttons are provided below each list to add new, edit, delete, run, email, or in the case of a query, to export to Excel. See below:
Click here to download this example.