Report to PDF error

[Homegrownandy]

When I press the button which triggers this code, the "output to " window does open. I can chose a network location and type the file name.

Private Sub Command26_Click()
 
DoCmd.OpenReport "Quote_Main", acViewPreview
DoCmd.OutputTo acOutputReport, "test", acFormatPDF, , True

End Sub

when I press ok I get the error:

2059


Microsoft accerss cannot find the object '|1'.

This is the stripped down version of the code. I am able to open the report with this and view it.. I can then also manually export it from the ribbon, so I'm confused where the problem is. Any ideas?

[andy49]

Does it happen when you choose a local location?


Sent from my iPhone using Tapatalk

[Homegrownandy]

Yes I'm just saving to my documents. I haven't tried to save elsewhere. (not in work right now to test)

[aytee111]

I am getting this same error when I try to save it to a location that I don't have write permission (even tho it looked like I should).

[andy49]

Yes I'm just saving to my documents. I haven't tried to save elsewhere. (not in work right now to test)

change the name of the report to remove the _

[Micron]

change the name of the report to remove the _

Is it not the name of the report that is being opened (Quote_Main), or am I misunderstanding and you are not suggesting to remove the underscore from the name of the report being opened?

I think either too much of the relevant code was not supplied, or an example of what name is being typed for the pdf version should have been provided. I seem to recall that this can fail with certain characters in a name for a pdf version while it will work for other formats. Or there is a similar problem with the file path chosen. OP might be using a file dialog folder picker and including extra quotes (or none where needed). And so on...

[andy49]

I managed to duplicate the error easily. But on changing the report name to quotemain (no underscore) the issue immediately resolved.


Sent from my iPhone using Tapatalk

[Homegrownandy]

Morning,

I have renamed the report to QuoteMain. Also, the code pasted is the entire code in use. There is plenty more i want to use but currently this is the only code associated with the button:

Private Sub Command26_Click()

DoCmd.OpenReport "QuoteMain", acViewPreview
DoCmd.OutputTo acOutputReport, "strReportName", acFormatPDF, , True

End Sub

In the first example of code it would attempt to name the PDF "test". In this one it will be "strReportName". This will be a variable in the future but right now its just text.

The file path is in my documents on my computer. If i manually create a PDF from the export ribbon then it does this with no problem.

[andy49]

Are you still getting the same error?


Sent from my iPhone using Tapatalk

[Homegrownandy]

Just tried saving this to desktop, and also to the shared network drive. Still no joy.

Edit: yes its the same error. on this line:

DoCmd.OutputTo acOutputReport, "strReportName", acFormatPDF, , True

By this point the report is open.

[andy49]

The strreportname is a variable right? If so why is it in ""


Sent from my iPhone using Tapatalk

[Homegrownandy]

Another update:

I thought maybe the data might be causing the error. Ive made a new report that has one text field from a table (no queries)

Still get the same error.

[Homegrownandy]

The strreportname is a variable right? If so why is it in ""


Sent from my iPhone using Tapatalk

It not a variable now. Im trying to eliminate anything that could be causing it. The code supplied is the code im using (no variables.)

[andy49]

It not a variable now. Im trying to eliminate anything that could be causing it. The code supplied is the code im using (no variables.)

DoCmd.OpenReport "QuoteMain", acViewPreview
DoCmd.OutputTo acOutputReport, "", acFormatPDF, "h:\test.pdf"

My latest version which works on my network

[Homegrownandy]

Ive also just tried this in a new database. Still the same. I'll try this same code on a new machine when one is available.