Error 2212 . . . couldn't print your object.

[notDave]

Short question.

After working successfully for about 2 years, I have a process that, within
the last month or so has starting failing. I have been getting the 2212
error when trying to output reports to the Adobe PDF writer. I have tried
installing all known updates to both MS and Adobe products as well as trying
full re-installs of Adobe Acrobat and the PDF Writer printer driver itself
etc, without any success. Any suggestions?

Detailed info:

I have a bit of code (shown at very bottom) that loops through a record set
and outputs a report, once for each record in the record set, and it puts the
date and the record value itself into the caption of the report, and sends it
to the default printer.

The default printer is the Adobe PDF Writer, which I have set to put all
created files into a particular folder, and to not prompt for a filename.
This means that the PDF Writer uses the caption sent to the print queue as
the filename.

As a result I get 3000 or so reports, each one filtered and named according
to the record value, and they all get dumped into a folder. We then move
those files to a different server and our employees can each access their own
paystubs online in lieu of receiving a printed paystub (Go Earth Day!).

Last month this process began to bomb. I get the "2212 Access could not
print your object." error. As mentioned above I have tried
updates/un-install-reinstall/etc. Anyone hear of something along these lines
that may help me trouble shoot?

Thank you all for any assistance you may have to offer...


~notDave

Code:

sql = "SELECT [badge] FROM [opa_data_table] GROUP BY [badge]"

Set myDb = CurrentDb()
Set myRs = myDb.OpenRecordset(sql)

While Not myRs.EOF

DoCmd.OpenReport "rpt_opa", acViewPreview, , "[badge] = '" &
myRs![badge] & "'"
Reports("rpt_opa").Caption = myRs![badge] & "_" & endDate &
"_Payroll_Advice"
DoCmd.PrintOut
DoCmd.Close acReport, Reports("rpt_opa").name, acSaveNo

myRs.MoveNext

Wend

 

[gtdp]

This is an old thread but did you ever get this figured out? I'm having this exact same problem. I have Access 2013 and had Adobe Acrobat Pro 9. When I upgraded to Windows 10 this happened on most of the computers in our office. I thought it maybe had to do with Acrobat Pro 9 so I installed a trial of Adobe Acrobat Pro DC but I'm having the same problem. I noticed also that when I manually opened and printed the report it sometimes prints and sometimes doesn't.