Report to pdf

[KEV999]

Any ideas please on how to click a control button set to automatically print a MS Access report as a pdf file and (if possible) then put it in a folder?

Using MS Access 2003 with db details as follows -
Database - db1
Table - table1
Report - report1
External folder - c:/folder1

Many thanks.
Kev

[Stewart Ross]

Hi. Access 2007 has the ability to output to PDF, but other versions do not.

However, the excellent Access developer Stephen Lebans has made available an example Access database that uses a unique approach to outputting reports to PDF. He outputs to Snapshot format first (.snp) then converts these to PDF without using any form of Adobe pdf driver.

His code is contained in a custom function and two DLLs (which are just downloaded to the same location as the database concerned - no other installation is needed). The example database and the DLLs are available zipped from his web site at http://www.lebans.com/reporttopdf.htm. You will need to do a little but of experimentation to use the print report to PDF function, but it certainly allows you to output a report direct to PDF, storing the pdf file in a suitable folder.

The code modules in the example database can be exported as necessary and imported into your own Access db. As mentioned, the DLLs stand alone and as long as they are located as per the notes in the example database no further installation is needed for these.

-Stewart

[KEV999]

Thanks, I'll give that a try.
Kev