Prev: "Enter key" default
Next: get data from a table not in a query
From: Mark Andrews on 26 May 2010 09:58
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


From: PieterLinden via AccessMonster.com on 26 May 2010 11:34
Mark Andrews wrote:
>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

--
Message posted via http://www.accessmonster.com

From: Mark Andrews on 26 May 2010 11:45
I would like to take a look at your example.

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

--
Mark Andrews
RPT Software
http://www.rptsoftware.com

"PieterLinden via AccessMonster.com" <u49887(a)uwe> wrote in message
news:a896329722083(a)uwe...
> Mark Andrews wrote:
>>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
>
> --
> Message posted via http://www.accessmonster.com
>
 | 
Pages: 1
Prev: "Enter key" default
Next: get data from a table not in a query