asked on

How do I get each page of a report to be output as a separate PDF file?

I have a report in Access that I output as a PDF file by using the following command:

DoCmd.OutputTo acOutputReport, "QueryAgenda", acFormatPDF, strStartDir & "Appeals_Committee_Agenda.pdf", False

What I would like to do is to be able to output each page of the report as a separate PDF file instead of a single PDF file with multiple pages which is what I am getting now.

Is there any way for me to accomplish this?

Thanks.

SOLUTION

Rgonzo1971

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geeta_m9

ASKER

I am assuming that this means I have to use a recordset with an SQL statement (to select a distinct ID) and loop through?

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geeta_m9

ASKER

The report uses a query. In the report query, wouldn't I have to set the criteria in the ID column as equal to the Me.ID. Otherwise won't I end up with the entire report for all the individuals each time?

Jeffrey Coachman

If the report/query normally displays all records, then no criteria is needed.

The code Rgonzo1971 posted simply filters the report for each ID

Git it a try, then let him/her know...

SOLUTION

geeta_m9

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geeta_m9

ASKER

Thank you for your help.