Run-time error '2059' (1 Viewer)

Arcadia · Apr 17, 2014

Hello, i have a question and hope someone can help me out here

In Access i have this VBA code to export a PDF file:

Private Sub Command17_Click()

DoCmd.OutputTo acOutputForm, "TrainingCalenderForm", acFormatPDF, "C:\Users\User\Documents\Trainingmap\Training.pdf"

End Sub

But when i click the button i keep getting this error:

Run-time error '2059':

Microsoft Access cannot find the object '|1'.

My head is starting to hurt can someone see what i'm doing wrong :banghead:

pr2-eugin · Apr 17, 2014

Does the TrainingCalanderForm based on a Query that requires a parameter??

Arcadia · Apr 17, 2014

Yeah the form is based on a query..

pr2-eugin · Apr 17, 2014

So what has happened to the second part of my question?

Arcadia · Apr 17, 2014

pr2-eugin said:
So what has happened to the second part of my question?

Yeah and also a parameter to insert the date..

The_Doc_Man · Apr 17, 2014

That particular error almost always means that some error has occurred in the form or report you were trying to output based on having named something in the form's RECORDSOURCE query or on a control's ROWSOURCE query, when you spelled the object wrong or named an object that didn't appear in the referenced query's underlying recordset.

I.e. the query processor failed to find an element in something that implies use of a query.

Arcadia · Apr 23, 2014

How can i solve it?

JHB · Apr 23, 2014

To a start, show the SQL-string for the query the form is based on.
Else post a stripped version of your database with some sample data, (zip it) + info in which form you have the button.

Run-time error '2059' (1 Viewer)

Arcadia

Registered User.

pr2-eugin

Super Moderator

Arcadia

Registered User.

pr2-eugin

Super Moderator

Arcadia

Registered User.

The_Doc_Man

Immoderate Moderator

Arcadia

Registered User.

JHB

Have been here a while

Similar threads

Users who are viewing this thread