Saving Access report as .pdf

[Guest]

Before printing a report, can I programmatically change
the printer to Adobe PDF and specify what I want the
saved .pdf file to be??

Thanks!

 

[SA]

Anon:

Access itself doesn't support outputting reports to specific PDF files.
Adobe as you've found doesn't have any macros for the Adobe PDF driver
(version 6) for Access either. You might want to look at our PDF and Mail
Library for Access. It supports outputting PDF files using the Adobe PDF
printer via VB code that can be as simple as:

Const PDF_ENGINE_ADOBE_PDF = 2
Dim objPDF as New PDFClass
With objPDF
.ReportName = "My Report"
.ReportWhere = "Some SQL Filter"
.PDFEngine = PDF_ENGINE_ADOBE_PDF
.OutputFile = "c:\some dir\some file.pdf"
.PrintImage
Debug.Print .Result
End With
Set objPDF = Nothing

The library will change the printer for you and output the report as your
PDF file. You'll find the Library on our web in the developer tools area.