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

 

[PieterLinden via AccessMonster.com]

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,
I did something like this with the paired listbox thing in ADH 2002 Desktop
Chapter 12.
I sent my data to Word, but not terribly different. Interface.. .right...
it's in there too. The MultiPik class. (Chapter 7).
I have a hopefully still working example I can send you if you want. It
"merges" a bunch of query results to a Word table... it's not the same, but
it does use methods of the ADO recordset that you an use in Excel.

Only hard part I found was that ADO does not seem to like Crosstab queries.
Or maybe I just didn't know where to find them in the ADO hierarchy.
(Entirely possible!) But since my crosstabs were fairly standard, I had an
empty table that I appended my crosstabs to and then used that to send the
data to Word.

HTH
Pieter

 

[Mark Andrews]

I would like to take a look at your example.

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