Export each page of report as a separate file

[Matt Williamson]

I need to be able to take a report that I'm creating and export each page as
a new .rtf file using one of the fields in the report as the filename. Is
this possible? I'm pretty good with VBA, but I haven't worked with it in
Access that much. There will be about 800 files created, so it needs to be
automated. A nudge in the right direction would be very helpful.

TIA

Matt

 

[GeoffG]

Matt:

I don't think you can save a report page-by-page as an rtf file.

I'd be inclined to use a loop in Access to create a fresh SQL statement for
the report based on the data you need in each of the 800 files and export
each resulting report to an rtf file.

Geoff

 

[Dale Fye]

I'm with Geoff.

I assume that the reason you want to break on each page is that each page of
the overall report relates to a different (person, office, product, ...)? If
that is the case, I think I would modify the reports recordsource so that it
checks a form or a variable for a value and only processes the report for
that value.

Then, I'd add some code that loops through all of those values, populates
the control on the form, exports the report, then repeats this loop for the
next value.

Dale