Reply to thread

Message: [QUOTE="notDave, post: 2128700"] 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 [/QUOTE]

Verification