How to create access report output in Adobe pdf format

[ncsthbell]

Hello,
Wanted to ask the best approach to handle this situation: My users want to be able to go into an access application, press a button and it run a report and the report automatically run and be saved to a certain location in Adobe pdf format. Can I use DoCmd.RunCommand 'acCmdOutputtoText' or 'acCmdPrintPreview'? Not sure how to save the results of running the report.

Any suggestions will be appreciated!!

[Jim Doherty]

Hello,
Wanted to ask the best approach to handle this situation: My users want to be able to go into an access application, press a button and it run a report and the report automatically run and be saved to a certain location in Adobe pdf format. Can I use DoCmd.RunCommand 'acCmdOutputtoText' or 'acCmdPrintPreview'? Not sure how to save the results of running the report.

Any suggestions will be appreciated!!

ncsthbell,

Please state your Access (97.2000,2003,2007) version to assist any contributors

Thanks

[ADezii]

Hello,
Wanted to ask the best approach to handle this situation: My users want to be able to go into an access application, press a button and it run a report and the report automatically run and be saved to a certain location in Adobe pdf format. Can I use DoCmd.RunCommand 'acCmdOutputtoText' or 'acCmdPrintPreview'? Not sure how to save the results of running the report.

Any suggestions will be appreciated!!

Access has no built-in functionality that allows you to Export Reports to *.PDF Format.

[AdrianGawrys]

U can install CutePDF client on his machine and set it as default printer, when user tries to print this report CutePDF will popup asking where to save .pdf document.
Hope this helps.

[ncsthbell]

ncsthbell,

Please state your Access (97.2000,2003,2007) version to assist any contributors

Thanks

I am running Access version 2000.

[Jim Doherty]

I am running Access version 2000.

Access 2000.....ok! have a look at Stephen Lebans ReportToPDF utility which converts your report to snapshot format and then from that to PDF

http://www.lebans.com/reporttopdf.htm

Regards

Jim :)

[ncsthbell]

I am confused about something with this. I have Adobe on my w/s. In my report in design view, I go up to the toolboar and select "File", the "Page Setup", click on the "Page" tab, select specific printer (Adobe PDF is listed) and I choose it. Of the other parameters you can set up, I have selected to be prompted for the file location to write the pdf. This sounds straight forward but after I set up these page setups for the report and run the report, it is like it doesn't run the definitions on PageSetup for the report. However, I can run the report, then click on "File", "PageSetup" and create the .pdf that way. Does anyone know why defining this on the page setup of the report will not create the .pdf file. I am running Windows 2000 on XP and Adobe Pro 8.