Save a Report to a PDF file. Access 2007

[casinc815]

I have an application where it has become necessary to save reports as a PDF file.



Our team has downloaded the add-in from Microsoft for saving to PDF. This file was an exe file
and was just under 1K in size. We have installed it on a single machine and am working with the
VBA code to save as a PDF via button click.

The code we have generated is:

DoCmd.OutputTo acOutputReport, , acPDFFormat, "C:\Documents and Settings\rpt_Student_ClassList.pdf", True

One error is it does not like the format designation, acPDFFormat. We have tried several variations of the
command line and have looked for several days to see what the alternative would be. Unfortunately, we
have not been successful. Has anyone been successful in Implementing the add-in and getting the report to
save to a PDF file?

Also, We have modified the ribbon so we are not allowed to do this manually. We want the users to work
from a button. Each report has a series of buttons to print, export, save and return to main menu. We are
working on the save button at the moment.

Thanks everyone.

Jim

[pbaldy]

You're not specifying the report, and try acFormatPDF. This works for me:

DoCmd.OutputTo acOutputReport, strReport, acFormatPDF, "c:\AccessAp\" & rs!CustomerAccount & "_Statement.pdf"

[casinc815]

If the report is the active report then a report name is not required according to the literature.

We will try your formatted statement and will let you know later.

Thanks for taking the time to read the post.

Jim

[casinc815]

WORKS LIKE A CHARM! MANY THANK YOU'S!

Jim

[pbaldy]

Happy to help! I know you don't have to supply the name, but I don't like to leave it to chance.