Report that can be exported to PDF based on field in report

[razkowski]

I have a report that shows employee compensation grouped by employee ID. I already force page breaks based on the employee ID's. Is it possible to generate the reports based on employee ID so they can be saved as individual PDFs, versus one large report that has all employees? Thanks

[pbaldy]

See if this gets you started, along with the looping code. You'd use OutputTo instead of emailing:

http://www.granite.ab.ca/access/emai...recipients.htm

You could also loop and use this:

BaldyWeb wherecondition

to open the report filtered before OutputTo. Basically this inside the loop:

DoCmd.OpenReport...
Docmd.OutputTo...
DoCmd.Close...