PDF filename

S

shank

A while back, someone gave me the below code so when the report was printed
the PDF filename was provided. Works great.

Now I have a totally different database with many reports.
I want the filename to be [Report Caption] in properties & Date formatted
like 121108
Example: Amco Inc 121108.pdf
How do I get that done?

thanks

I tried editing the below, but keep getting syntax errors.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Private Sub Report_Load()
DoCmd.OpenReport "repSelectPO", acViewPreview, , "PO " & Me!PONo
Reports("repSelectPO").Caption = "PO " & Me!PONo
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save Report to PDF with a Custom Filename & Email.. 0
create PDF filename 1
PDF the Excel Report 3
automate save as PDF with Name 5
Kallal's print rpt to pdf 1
Macro Loop 0
how to change the filename of a send report 0
Automatically name a report when exporting to PDF 1

Top