Combo box list table field

[kiwibirdsong]

I am hoping you might help.

I am trying to create a form that will run a generic report.

I have a combo box that will show me the available fields in a pre
determined table/query however what I would like to do is have a list or
combo box from where I can select a particular query and then have my
current combo box update with the fields within the query.

This is hard to explain. I'm hoping this makes sense and someone may be
able to help.

My overall task is to have a list from where I select a pre created query.
I would then have a combo box that would show me the fields available in
that query.
I would then be able to select the fields I wish to include in the report.
My next hurdle will be then to create a way of taking the results and
placing them into an excel spreadsheet.

WHEW... I await any help anyone can offer. Maybe I have really bitten off
more than I can chew this time.

Please keep your instructions simple as I have limited knowledge with VB and
still learning lots with Access.

Again thanks
Kiwi

 

[Duane Hookom]

This is all done for you in the Query By Form applet demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You
basically import some objects into your mdb and then create some "master"
queries with names beginning with "<". Users can then select a master query,
fields, sorting, criteria, grouping, etc. The results are displayed in a
subform with about two clicks from viewing the records in Excel. You can
also send the results Word, CSV, graph, form letter, html, print,...

 

[kiwibirdsong]

I have to dash out but will look at this as soon as I get back.

Thanks so much for your prompt reply

I will feedback to the group

Kiwi

 

[kiwibirdsong]

Wonderful application. It looks just like what I need.
Any objections to me using in in an application?

I may need to change things a bit but will leave any acknowledgements you
want.

Again thank you and You are a HERO.

For ever in your debt.
Kiwi

 

[Duane Hookom]

I make the applet available for you to use in your internal applications. If
you want to put it in an application to sell, then we need to talk.

 

[kiwibirdsong]

We need to talk. I am doing this for an application I have already created
and continue to work on.

They now require me to produce a method to create reports as and when they
need them.

In the past I have created reports when they needed them.

Do you want to discuss this outside of this forum. If so please feel free
to e-mail me.

Cheers
Kiwi