parameter query

[ziako]

Dear All,

I am having problems finding a solution to this problem. I am working on 3 databases at the moment..and am at the final hurdle to complete it.
I have built an Access database. I would like to generate a
number of reports which have to be exported directly into excel
individually.

I have a parameter query with 14 columns. One of the columns
is called GROUPS. I have a form with a button.
When you click on the button the parameter query asks for the
parameter value.

The parameter value must be a GROUP. i.e BURR, WIEN.

After you enter the group the parameter query generates results for
that particular group.


I have a number of groups which i would like to generate results
for at the click of the button on the form.

There are around 30 groups. but i only need to generate reports for
about 15 groups. The groups are stored in one of the tables.


So for instance after i click a button on the form
the results for each requested "GROUP" are exported individually into
excel.

Each group result must be in one excel file.

How can i achieved this. Do i need to use VBA? Please can you help.
I need a solution then i can apply this to a number of databases

Many, Many thanks

 

[FoFa]

Maybe I am making this too simple, but can't use a combobox to only display the 15 groups you need, and when the button is clicked creates the proper excel file for you?
You could always detect the group selected to generate the file. You can use macros or VBA to do this. I think VBA would be less code because for a Macro you would basically need one section of macro code for each selection possible, where in VBA you can use a SELECT CASE to set variables, at least in my opinion.