Export to PDF

  • Thread starter Thread starter Maureen
  • Start date Start date
M

Maureen

Hi - I am trying to have a report automatically generate
a PDF document.
I am able to set the report to default to my pdf driver -
but it then comes up asking for a file name.

What I really is for the file name to automatically
generate from a field in the record of the report.

Any help would be very much appreciated.
 
Maureen:

This depends on the PDF printer driver that you are using. Access has no
built in facility to output PDF files or to set a file name for output
(except for its supported data types like RTF, XLS etc.)

Our PDF and Mail Library supports the PDF drivers from Adobe (v 3-6),
Win2PDF, pdfFactory, PDF995, Amynni and PDF 4 U. Once you set the proper
target driver you are using the VBA code you can add to a command button on
a form can be as simple as the following:

Dim objPDF as New PDFClass
Const PDF_ENGINE_ADOBE_PDF = 2

With objPDF
.ReportName = "Your Report"
.PDFEngine = PDF_ENGINE_ADOBE_PDF
.OutputFile = "c:\some dir\some file.pdf"
.PrintImage
End With

You'll find the Library on our web site in the developer tools section
 
Thanks for your reply.
This utility looks very interesting.

Do you know if it is possible to set the name of the
document to a field from the report? ex [OrderIdNo]?
thank you again
 
Maureen:

If as an example your report might contain multiple orders and you want to
output various PDF files, i.e. one for each order, the Library's help file
shows you how to loop through a record that might underly the report (with
all the order numbers) and output one file per order number using a SQL
WHERE clause when the PDF file is created. If you have the order ID from
that record set you can then set the file name to anything you want.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Maureen said:
Thanks for your reply.
This utility looks very interesting.

Do you know if it is possible to set the name of the
document to a field from the report? ex [OrderIdNo]?
thank you again
-----Original Message-----
Maureen:

This depends on the PDF printer driver that you are using. Access has no
built in facility to output PDF files or to set a file name for output
(except for its supported data types like RTF, XLS etc.)

Our PDF and Mail Library supports the PDF drivers from Adobe (v 3-6),
Win2PDF, pdfFactory, PDF995, Amynni and PDF 4 U. Once you set the proper
target driver you are using the VBA code you can add to a command button on
a form can be as simple as the following:

Dim objPDF as New PDFClass
Const PDF_ENGINE_ADOBE_PDF = 2

With objPDF
.ReportName = "Your Report"
.PDFEngine = PDF_ENGINE_ADOBE_PDF
.OutputFile = "c:\some dir\some file.pdf"
.PrintImage
End With

You'll find the Library on our web site in the developer tools section
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg




.
Click to expand...
Click to expand...
 
Back
Top