Routine to run/export queries

[Mark Andrews]

Looking for some links to examples that do the following (or something
close):

1. user would create a whole bunch of queries themselves (using Access)
2. form that lets the user runs these queries to display results and/or
export
3. Would be good if user could select multiple queries and get multiple
resultsets to display or be exported to
an excel file with multiple worksheets. Example: user selects 5 queries and
wants an excel file made with 5 tabs with the 5 different outputs of the
queries, or the outputs of the 5 queries show in a form with multiple tabs
in Access (hide/show tabs, set recordsources at runtime etc...).

Perhaps ability to use a table to track:
- queryname
- short description
- long description
- sort order

so this table could be setup to be used in the multi-select list box in #2
above.

I don't need someone to explain how I would build this, just looking for
code in case someone already built this exact thing or something close.

Thanks in advance,
Mark

 

[Mark Andrews]

I would like to take a look at your example.

You can find my email on the contact page of the website.