Hi
i want to save the report to a specific folder with customer name [From textbox]. can someone please help me the code to use.
Thanks in advance.
Hi
i want to save the report to a specific folder with customer name [From textbox]. can someone please help me the code to use.
Thanks in advance.
DoCmd.OutputTo, concatenating the textbox value into the file name argument.
Hi
i tried above code but its not working.Code:DoCmd.OutputTo acOutputReport, [ReportName], acFormatPDF, "E:\New folder\" & ".PDF", True
You need to add a file name: "E:\New folder" & "FILENAMEHERE.PDF"
e.g. "E:\New folder" & Me.CustomerID & ".PDF"
or possibly "E:\New folder" & " & Me.CustomerID & " & ".PDF" ????
HI
Ridders
tried above, but not working. any suggestionCode:DoCmd.OutputTo acOutputReport, [Reportname], acFormatPDF, "E:\New folder\" & Me.Combo21 & ".PDF", True
The report name must be in quotes.
Hi Guys
Thank you for taking time to give me a solution.
ORCode:DoCmd.OutputTo acOutputReport, "Report2", acFormatPDF, "E:\New folder\" & Me.Text34 & ".PDF", True
Both the above code works fine to save a report in PDF format on a specific pathCode:Dim FileName As StringDim FilePath As String FileName = Me.[TextboxName] FilePath = "Path" & FileName & ".pdf" DoCmd.OutputTo acOutputReport, "Report Name", acFormatPDF, FilePath MsgBox "Report Saved Successfully"
Happy to help.
Ditto.
Eranka - did you see my solution to the 8 letter password question to also cover checking for both upper & lower case letters