Dear All,
I want to save Raport in pdf by name, depending on the information in the Claimnumber ( textbox) and City (combobox) With below macros I get the results. 235645262.PDF instead of 23564526 BDN. PDF
Claimnumber = 23564526
City (combobox) :
ID data type
1 DPS
2 BDN
3 JKT
I hope you can help with the macros.
I want to save Raport in pdf by name, depending on the information in the Claimnumber ( textbox) and City (combobox) With below macros I get the results. 235645262.PDF instead of 23564526 BDN. PDF
Claimnumber = 23564526
City (combobox) :
ID data type
1 DPS
2 BDN
3 JKT
I hope you can help with the macros.
Code:
Private Sub SAVE_To_PDF_Click()
Dim FileName As String
Dim FilePath As String
FileName = Me.Claimnumber & " " & Me.City
FilePath = "C:\MS ACCESS\" & FileName & ".PDF"
DoCmd.OutputTo acOutputReport, "Report", acFormatPDF, FilePath
MsgBox "Done", vbInformation, "Save Confirm"
End Sub