Exporting multiple reports via macro

[Guest]

I'm trying to create a macro that will automatcally export and save multiple
reports from a macro. I have a query that generates a list of names that I
would like to 'step through' to generate each report (something easily done
in Excel, but apparently not so much in Access).

The only other way I can think of to do this is create *shudder* 300+
macros, one for each name.

 

[Steve Schapel]

Nathaniel,

Doing this with a macro probably needs to involve:
- make a continuous view form with your list of names
- make a macro to...
- export a report for the name of the current record on the form
- use GoToRecord action to move to the next record on the form
- make another macro using the RunMacro action, to run the export
macro, with a suitable Repeat Expression argument, so the export is run
for each name.

However, this would be simpler to do using VBA procedure rather than macro.

 

[Guest]

Thanks Steve, your advise was very helpful!

Nathaniel,

Doing this with a macro probably needs to involve:
- make a continuous view form with your list of names
- make a macro to...
- export a report for the name of the current record on the form
- use GoToRecord action to move to the next record on the form
- make another macro using the RunMacro action, to run the export
macro, with a suitable Repeat Expression argument, so the export is run
for each name.

However, this would be simpler to do using VBA procedure rather than macro.