Report to PDF with Custom Name

[murtazakhambaty]

Hi

I am writing the following code but its keeps on giving error. Can you please help.

Private Sub ReporttoPDF_Click()

Dim sFPath As String

sFPath = "D:\Adobe Documents\Quotation\ & Me.QuotationID & Me.QuotationYear & " --- " & Me.Company & " - " & Me.BACity"
sFPath = sFPath & Me.QuotationID & Me.QuotationYear & " ---" & Me.Company & " - " & Me.BACity & ".pdf"

DoCmd.OutputTo acOutputReport, "", acFormatPDF, sFPath, False

End Sub

I want my PDF file to save as follows:

XYZ-XYZ10000-2014 --- ABC-City.pdf

 

[pr2-eugin]

What is the error? Without knowing that, we will be chasing the tail here.

 

[murtazakhambaty]

The Error is

Compile Error: Method or Data member not found

 

[Minty]

What version of access? pdf output isn't supported until 2007

 

[murtazakhambaty]

I am using Office 2010.

 

[pr2-eugin]

Which line does it highlight? Why is there no report name specified?

 

[murtazakhambaty]

Error is on line 3 and 4 both.

 

[Gasman]

You have an error in the first line of sFPath. I think it should be

sFPath = "D:\Adobe Documents\Quotation\ " & Me.QuotationID & Me.QuotationYear & " --- " & Me.Company & " - " & Me.BACity


HTH