Results 1 to 5 of 5
  1. #1
    PiedBlueberry is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    2

    Copy&Pasted report, but new report "OnPrint" error when trying to view print preview

    Hello everyone,
    (If I posted in the wrong section, I'm sorry!)

    Overview
    In an Access file, data is converted into reports that are then printed. There are a couple of reports that already accomplish this, and I need to add a similar report. So I tried to copy and paste the existing reports and edit it a bit, but I am getting the following error even though I haven't changed anything:


    Click image for larger version. 

Name:	1.PNG 
Views:	9 
Size:	7.8 KB 
ID:	36103

    Database
    Here is a cleaned version of my database:
    (Removed)

    Database Instructions
    To use the database, open up the Navigation_PAGE form. Then:
    Click image for larger version. 

Name:	2.PNG 
Views:	9 
Size:	34.8 KB 
ID:	36104 select a date, "Select All", select the label and then "Open Report".
    For label 1, the following report should be printed out: Click image for larger version. 

Name:	3.PNG 
Views:	9 
Size:	15.7 KB 
ID:	36105

    Objective
    Basically, Label1 and Label2 (in the label selector, step 4 above) both work. However, Label3 (which was copied and pasted from Label1 and modified slightly) is getting that error message. I am trying to find a way to get Label3 to work


    Could anyone help me find a solution for this problem?
    Sorry if this is confusing; I'll provide more details if needed!
    Thank you so much!
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,523
    IS there code in the ON PRINT event?

    if not , then the message is a misnomer,
    it usu means theres a MISSING item(s) in the REFERENCES.
    enter VBE, (alt-F11),
    menu: tools, references,
    see if any checked items say MISSING.
    uncheck these items. Sometimes the newer version is in the list.

    that there is a field with a bad source...a calculation?, a missing field in the query?
    a DEF or PRIVATE definition that no longer works,

  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
    Haven't run the code but this in the detail section's On Print event:

    =LabelLayout([Reports]![Fillets_LABEL])

    refers to a report that doesn't exist.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    PiedBlueberry is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    2
    Oh my god! I thought I checked the On Print event already ... Well, this is embarrassing.
    Thank you so much, ranman256 and pbaldy!!

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem, we've all done it.
    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. Report View VS Print Preview
    By deepakg27 in forum Reports
    Replies: 4
    Last Post: 07-04-2018, 08:20 PM
  2. Replies: 4
    Last Post: 03-02-2018, 09:11 AM
  3. Replies: 3
    Last Post: 04-28-2017, 09:51 AM
  4. Replies: 10
    Last Post: 09-03-2015, 01:31 PM
  5. convert report view to print preview
    By DarrenUD in forum Reports
    Replies: 3
    Last Post: 03-19-2013, 12:21 AM

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