A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Saving Access report as .pdf



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2004, 01:32 PM
external usenet poster
 
Posts: n/a
Default 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  
Old May 19th, 2004, 03:55 PM
SA
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.