Save report as PDF with name derived from report filed

[rrciesla]

Hello,



I have a report (Purchase Order) that needs to be saved as a PDF. I put a button on the report to do this but I would like the PDF to automatically draw it's name from the PO Number field on the report and save it to c:\Purchase Orders folder. Can this be done?

[June7]

Yes. Reference field. Are you using OutputTo command? Show your code.

Button won't work on report in PrintPreview.

[ranman256]

vRpt ="InvestRpt " & Me.Code 'This is the name I want to call my file
vFile = "c:\folder" & vRpt & ".pdf"
docmd.OutputTo acOutputReport ,"rMyReport",acFormatPDF,vFile

[rrciesla]

June7, I don't code. Not a programmer. I am building this database using the visual tools. Can I send you a copy? It's about 11 mg.

[rrciesla]

June7, I have compact/repaired and compressed the file. I appreciate your help.

[rrciesla]

ranman256,

I inserted the code you suggested with changes. I changed "InvestRpt" to "PurchaseRpt", Me.code changed to me.PO_Number (PO_Number is the field from which I want to draw the file name.) I changed the "c:\folder" to the folder I want to save to.
Now when I click the Save to PDF button I get an error that says "Run-time error '2059' Cannot find object '|1'."
Any suggestions?

[June7]

You have button on form, not report.

You have to code in something - either macros or VBA. You appear to be using macros. I don't use macros.

Set the OutputFile argument to:

"C:\Purchase Orders\" & Forms![Purchase Order View by PO number_f]![PO Number] & ".pdf"

That should work but isn't for me. VBA does work:

Private Sub Save_PDF_Click()
DoCmd.OutputTo acOutputReport, "PO Report by PO number", acFormatPDF, "C:\Purchase Orders\" & Me.[PO Number] & ".pdf"
End Sub

Data structure is wrong. Should not have multiple tables for ChangeOrders, Contracts, Customers, Employees, Labor, Purchases, Sales, Vendors. Why do you do this?


Strongly advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.

[rrciesla]

June7,

That works. Thank you so much. The reason for the multiple tables is I don't know any better. But this works for my needs.