Results 1 to 6 of 6
  1. #1
    jtuel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    2

    Angry can't print volenteer button give me this 3071 error code

    a window pops up asking to debug and then gives me these four windows in the attachment can you help me and tell me how to fix please
    Attached Thumbnails Attached Thumbnails Capturedatabase code.jpg  

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    When does this code popup? From Where? Are you needing to Link any Criteria?

    Try this:

    Dim strReportName As String

    strReportName = "Hours By Volunteer"
    DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I don't know what the text of 3071 is offhand, but does the report open from the Navigation Pane without error?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    jtuel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    2
    it didn't seem to change anything but i get a preview now which we didn't have before! thanks

  5. #5
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Glad you made progress. Debug your app one line of code at a time.

    Good Luck!

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I don't think using an undeclared variable would help, so I'm guessing something else changed. You might find this relevant:

    http://www.baldyweb.com/OptionExplicit.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 07-30-2014, 03:55 PM
  2. Query Error 3071
    By fooforever in forum Queries
    Replies: 4
    Last Post: 04-15-2011, 06:15 AM
  3. Help with Error (3071)
    By ron3rbns in forum Access
    Replies: 1
    Last Post: 03-05-2011, 01:56 AM
  4. Need help with Error (3071)
    By ron3rbns in forum Queries
    Replies: 0
    Last Post: 03-03-2011, 10:35 AM
  5. Error in Print Report Button
    By Robert M in forum Reports
    Replies: 16
    Last Post: 09-23-2009, 03:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums