save Access report as PDF file

  • Thread starter Thread starter gina
  • Start date Start date
G

gina

Hi

Is there a way to have Access convert and save an access report as a PDF
file in a specific folder using VBA code.

The PC has Acrobat 6 Professional.

I have spent so much time on this problem it's causing me so much grief - so
any support you can give will be sooooooo appreciated.

Gina
 
Hi gina!

Did you ever think in use a printer driver that generates directly a PDF
file of the print you need?

If you are interested, try:
software995.com It works and it is free...

KRAD
 
We sell code to do this. However our code currently only works with win2pdf
and adobe PDFWriter version 5 and earlier. You can buy win2pdf for $35 and
our code for $99.95 and have a solution. Otherwise look into
how to set various registry settings with whatever pdf driver you are using
(however adobe 6.0 is a more difficult path than simple registry settings).

HTH,
Mark
RPT Software
http://www.rptsoftware.com
 
Gina:

Try stopping by our web and looking at our PDF and Mail Library for Access.
It will work with Acrobat 6 to output PDF files from Access reports via VBA
Code.
 
Gina

I have done this by using the Acorbat Distiller that should come the
professional version. To get the unique file names so that acrobat does not
over write these file open the report change the caption and docmd.close
"report, acsave. Set your default printer as the acrobat distiller. I hope
this helps. My app runs hundreds of pdf reports in a week. What about using
Snapeshot??
 
Back
Top