If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Saving Access report as .pdf
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! |
#2
|
|||
|
|||
Saving Access report as .pdf
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. -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|