export access report to pdf format

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

does anyone know if it is possible to use VBA code to
export to a pdf format? i currently use the following
command line to export to snapshot.

DoCmd.OutputTo acOutputReport, "rptName", "??
acFormatPDF ??", "c:\rptName.pdf"

thanks, dave
 
I have an application that is doing this for many reports in
a multi-user situation. In order to make this work I did
have to use an outside utility as an add in. I found the ACG
PDF Pro Library on the net and it works really well to
automatically convert a report to PDF and then attach it to
your email, allowing you to send the email automatically if
you want. Works with the Adobe Acrobat Distiller, and with
PDF995, the practically free PDF creator as well. Here is
the URL for the site...

http://ourworld.compuserve.com/homepages/attac-cg/acgpdf.htm

Disclaimer: I have no interest in the above addin except
that I am using it and it is working for me. Hope this saves
you the many hours of exploration and research that I put in
to trying to do it myself <gr>.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top