By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,025 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Report to pdf

P: 21
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
Nov 20 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
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
Nov 20 '08 #2

P: 21
Thanks, I'll give that a try.
Kev
Nov 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.