Exporting query results to Excel

[Donna]

I have a form that has a list box with contents as follows: ENGA, ENGB,
ENGC, ENGD, ENGE, ENGF, 1, RIP, RAC. The user selects one of the items in
the list box & I have a macro set to run as soon as the item is selected that
will run a query. Ideally, what I would like to have happen is that the user
can select an item, run the query, have it export it to an excel spreadsheet,
then let the user select the next item in the list box, run the query &
append the excel spreadsheet that was created from the first choice. The
user should be able to keep choosing as many items as he or she wants. The
items would be sorted in alphabetic order by ENGA, etc. What is the best way
to go about doing this?

 

[John Nurick]

Hi Donna,

If you want to export to a single worksheet, you need to use a
multi-select listbox where the user can select all the items needed.
Then have a commandbutton with VBA code in its Click event procedure
that assembles the selections from the listbox into a SQL statement for
the query. There's sample code at
http://www.mvps.org/access/forms/frm0007.htm
and
http://support.microsoft.com/?id=135546