Automating - converting MS Access reports to PDF files using VBA

R

Rob

Does anyone know how to convert access reports to pdf
files using vba? Currently, I'm running an access 2000
database which distributes static snap shot access reports
via outlook. I would like to move the static reports to
PDF files for easier distribution.
 
R

Randall Arnold

The easiest method I know of is to simply employ a PDF "print driver" such
as Adobe's Acrobat PDFWriter, which comes with Acrobat (there are third
party solutions as well). Use VBA to call the printer and select that
driver.

Anyone doing any sort of developing around PDFs should check this site:

www.planetpdf.com

Randall Arnold
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Access Database to build contracts with fields on pdf document 0
Viewing files content inside MS-Access form 1
How to close a *.PDF report in VBA 0
Converting text to PDF 0
Appending mutiple reports to PDF using VBA. 4
PDF files to MS Access 2007 (ODBC) 0
why won't my xml file print to a pdf 0
Combining multiple reports into one report or PDF 4

Top