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


    ~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
     
    notDave, Apr 22, 2009
    #1
    1. Advertisements

  2. notDave

    gtdp

    Joined:
    Jul 12, 2016
    Messages:
    1
    Likes Received:
    0
    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
    #2
    1. Advertisements

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.
Similar Threads
  1. jon
    Replies:
    0
    Views:
    296
  2. AlexD

    database engine couldn't lock a table

    AlexD, Apr 12, 2004, in forum: Access VBA Modules
    Replies:
    3
    Views:
    181
    Tim Ferguson
    Apr 14, 2004
  3. Wasi

    couldn't open mdb files in Access 2003 runtime

    Wasi, Oct 15, 2004, in forum: Access VBA Modules
    Replies:
    0
    Views:
    122
  4. ndunwoodie

    Another "Couldn't Update, Currently Locked" err

    ndunwoodie, Sep 15, 2005, in forum: Access VBA Modules
    Replies:
    1
    Views:
    135
    Dirk Goldgar
    Sep 16, 2005
  5. JWS315
    Replies:
    4
    Views:
    265
    Dabaum
    Sep 26, 2006
  6. Appache
    Replies:
    0
    Views:
    119
    Appache
    Jun 12, 2006
  7. Lynn He

    couldn't update; currently locked

    Lynn He, Feb 7, 2008, in forum: Access VBA Modules
    Replies:
    1
    Views:
    212
    boblarson
    Feb 9, 2008
  8. rhc
    Replies:
    7
    Views:
    200
    Chris O'C via AccessMonster.com
    Jul 25, 2008
Loading...