pdf file name from field?

[gtslabs]

I want to print my report to a pdf file but the default file name is
always my report name. Can I reference a field in my report for the
new pdf file name?

 

[Brian]

How are you creating the PDF? Is this via code, or just printing to Acrobat
or CutePDFWriter or some other PDF creator.

I'm not sure if there is a way to do it directly, but if your report has a
Caption, the Acobat print engine is likely pulling from the Caption, not the
report name itself. My poor-man's solution might be to do this just before
opening the print dialog:

Me.Caption = ExportName 'where ExportName contains the value you want
Acrobat to use for the file name.

Then change the Caption back after the print.

There is probably a more sophisticated way.

 

[Brian Carlson]

Brian:
Could you please give greater detail on the make shift method you
have mentioned? I would like to create a command button on some forms and
reports that would save a PDF file with the filename being pulled from one of
the form/reports fields? In addition, if I wanted to have a command button
on the form that printed a PDF of a report associated with this records,
would I need this button to perform some action to ensure the data in the
form has been saved? Thank you in advance.

Brian

 

[Brian Carlson]

Brian:
I am wondering if you could provide some additional detail on the
suggestion you provided. I would like to use a command button to print
reports and forms to PDF, having the filename of the PDF pulled from a field
within the field or report. In addition, I am also wondering if I want to
have a ‘print to PDF’ command button on a form that prints a report
associated with the form to PDF, how do I ensure that the data in the form
has been saved in the table and thereby is able to be printed. Thank you in
advance.

Brian