Run an Access 2007 report and export this report to PDF programmatically?

Question

I have a great report in an Access 2007 database and you want to automate the execution and export of this report. Is this possible, and what would be your first assumption regarding the method needed to remove it?

Answer 1

You should be able to automate the use of the DoCmd.OutputTo method. I think that the PDF function requires SP1 for A2007. Here is a simple example:

DoCmd.OutputTo acOutputReport,"rptFoo",acFormatPDF,"D:\Access\rptFoo.pdf"

Take a look at the MSDN page for more information: DoCmd.OutputTo Method

Answer 2

: http://msdn.microsoft.com/en-us/library/bb238050(office.12).aspx http://msdn.microsoft.com/en-us/library/ee336132(office.12).aspx