Any code out there to convert saved reports to PDF?

  • Thread starter Thread starter jen
  • Start date Start date
J

jen

Want to create the report (built in Access 2000 as a
template)and be able to save as a PDF file. Currently save
as .snp or .rtf and then convert to PDF using a converter.
Any of you written any code to do this? It could be a box
on the user form with choosing PDF save as an option.
 
Jen:

Stop by our web and look at our PDF and Mail Library for Access. It
supports many pdf drivers and allows you to create a pdf file from a saved
report with code as simple as:

Dim objPDF as New PDFClass
With objPDF
.ReportName = "YourReportHere"
.ReportWhere = "[CustomerID] = 1212334"
.OutputFile = "c:\somedir\some file.pdf"
.PDFEngine = 2
.PrintImage
End With
Set objPDF = Nothing

You'll find it in the developer tools section of our web.
 
Back
Top