How to send a report to a pdf file using code

[Gan]

I am trying to send the output from a report to a pdf file that I will name but I can't seem to get it working:
I am using this simple command that is associated with the click event of a command button:
DoCmd.OutputTo acOutputReport, "CE7" , acFormatPDF, "testFile.pdf"

The name of the report is CE7 and the name of the pdf file to output is testFile.pdf.
I am getting the following error. The report works fine. Is the above syntax correct. What am I missing?


Thanks for your feed back

[June7]

I don't see anything wrong with the syntax, works for me. However, you don't specify the full destination file path. The code works but do you know where the file will end up? I found mine in C:\Temp and I don't know why, maybe because it was the last folder I was in.

Image in your post is not showing.

[ssanfu]

Welcome to the forum.....

You didn't specify what the error message is.

Help says that the outputfile is: "A string expression that's the full name, including the path, of the file you want to output the object to."

Instead of "testFile.pdf", try adding the drive and path -> "C:\MyFolder\testFile.pdf" (or whatever path you need)

[Gan]

I don't see anything wrong with the syntax, works for me. However, you don't specify the full destination file path. The code works but do you know where the file will end up? I found mine in C:\Temp and I don't know why, maybe because it was the last folder I was in.

Image in your post is not showing.

I have attached the error.
Doc1.pdf

Thank you for taking the time out to reply. I really appreciate it.

[June7]

Sorry, that doesn't help explain why you get error. I still don't see anything wrong with the code.

However, as stated, you should use a full folder/file path.

[Gan]

It is more a mystery why the same code works on your computer but does not work on mine. I used the fully folder/file path. Here is the code:
Private Sub Command20_Click()
Dim FileName As String
FileName = "c:\CeDownload\pdf\ReportA.pdf"
DoCmd.OutputTo acOutputReport, "ce7", acFormatPDF, FileName
End Sub

Thank you again for your help.

[Gan]

Ignore my previous post - I was able to get it to work after re-creating the function from scratch. The generated error message suggests a problem with the function name: The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]

Thank you for your help.

[Gan]

A followup question to my previous post -
I want to save each of the report form generated with the name associated with the account number field of each record that meets a criteria. Currently, this

Private Sub Command20_Click()
Dim FileName As String
FileName = "c:\CeDownload\pdf\ReportA.pdf"
DoCmd.OutputTo acOutputReport, "ce7", acFormatPDF, FileName
End Sub

works with all the reports save as one pdf file. I need a single pdf file saved for each record of the file with the name matching the account number of each of the records.
Any help will be greatly appreciated.
Thank you.

[June7]

Review https://www.accessforums.net/import-...ges-25042.html