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
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.
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.
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.
