N
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
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