How to save output file name based on PO Number when exporting to PDF

[Niko]

Hello guys, how to have the PDF name based on the PO number when it export from access to PDF file?


Currently, when i click on the button "Export to PDF" on my form to export my purchase order report to report, the file name of the exported PDF file will be save as the same name as my report which is not what i want. Firstly, it is because it might be hard for user to know which file belong to which PO number. Secondly, it will cause lots of duplication files like Report,Report(1),Report(2) and the list goes on. Therefore, I would like to name the PDF file as the PO number before exporting to PDF.

[June7]

Are you using DoCmd.OutputTo method? Use the OutputFile argument to construct the path\filename with concatenation.

"path" & Me.PONumber & ".pdf"

[Niko]

Are you using DoCmd.OutputTo method? Use the OutputFile argument to construct the path\filename with concatenation.

"path" & Me.PONumber & ".pdf"

Yes I am. i have error with my code which say "The outputto action was canceled."

Private Sub cmdSavetoPDF_Click()
Dim filename As String
Dim filepath As String


filename = Me.txtMXDPO.Value
filepath = "C:\Users\User\Desktop" & filename & ".pdf"
DoCmd.OutputTo acOutputReport, "MXDReport<Keep>", acFormatPDF, filepath
MsgBox "Report have been save successfully", vbInformation, "Save confirmed"


End Sub

[June7]

Need another \.

filepath = "C:\Users\User\Desktop\" & filename & ".pdf"

Advise not to use spaces nor punctuation/special characters (underscore only exception) in names for anything.

[Niko]

Need another \.

filepath = "C:\Users\User\Desktop\" & filename & ".pdf"

Advise not to use spaces nor punctuation/special characters (underscore only exception) in names for anything.

Still same error

[June7]

The method works for me.

You have a user named User?

What is the value in the textbox?

[Niko]

The method works for me.

You have a user named User?

What is the value in the textbox?

Yes, because i log in as user.
The value in the text box = ABC17/101

[June7]

Filename can't have / character. Other forbidden characters: \ : * ? " < > |

[Minty]

@June this thread might make you aware that this was mentioned sometime ago... https://www.access-programmers.co.uk...2&postcount=29

[June7]

Does look like the same poster even though usernames are different.

My earlier warning about special characters was intended for Access objects (table, query, form, report, controls). Better would be MXDReport_Keep. Now expand that advice to the structure of PO number, although a hyphen (-) would be acceptable. I use a hyphen for a document ID like: 2017A-0001.

I create that document ID with VBA as the sequence must restart each year. Review https://www.accessforums.net/showthread.php?t=23329

[Niko]

Does look like the same poster even though usernames are different.

My earlier warning about special characters was intended for Access objects (table, query, form, report, controls). Better would be MXDReport_Keep. Now expand that advice to the structure of PO number, although a hyphen (-) would be acceptable. I use a hyphen for a document ID like: 2017A-0001.

I create that document ID with VBA as the sequence must restart each year. Review https://www.accessforums.net/showthread.php?t=23329

I removed and it works now. Thanks