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

Discussion in 'Access VBA Modules' started by notDave, Apr 22, 2009.

  1. notDave

    notDave Guest

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



    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 &
    DoCmd.Close acReport, Reports("rpt_opa").name, acSaveNo


    notDave, Apr 22, 2009
    1. Advertisements

  2. notDave


    Jul 12, 2016
    Likes Received:
    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.
    gtdp, Jul 12, 2016
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.