Outputting a report to pdf

  • Thread starter Thread starter Sue
  • Start date Start date
Sue:

There's no built in way to output an Access report to a PDF file
automatically. You'd have to use a third party tool to do so. If you use
either Adobe Acrobat, Win2PDF, pdfFactory, or PDF995 drivers, then you might
look at our PDF and Mail Library for Access, which will allow you to output
a report to a PDF file with as little VB code (say from a command button on
a form,) as:

Dim objPDF as New PDFClass
With objPDF
.ReportName = "Your Report"
.PDFEngine = 3 'Using Win2PDF driver
.OutputFile = "c:\some dir\some file.pdf
.PrintImage
End With

HTH
 
Sue,
I was just trying to do the same thing you are.

To get it to work, I have the report printed with the Adobe PostScrip
Printer Driver (set to print to file), I wrote a small program to fil
in the text box on the filename prompt. Then I use a call to anothe
program (Ghostscript) that converts the print file to PDF. It work
pretty good in all my tests, but I haven't had time to test i
completely.

If you are interested, let me know.

Nord
 
Sue,
I was just trying to do the same thing you are.

To get it to work, I have the report printed with the Adobe PostScrip
Printer Driver (set to print to file), I wrote a small program to fil
in the text box on the filename prompt. Then I use a call to anothe
program (Ghostscript) that converts the print file to PDF. It work
pretty good in all my tests, but I haven't had time to test i
completely.

If you are interested, let me know.

Nord
 
Back
Top