Exporting multiple reports via macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Thanks Steve, your advise was very helpful!

Steve Schapel said:
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.
Click to expand...
 
Back
Top