Results 1 to 4 of 4
  1. #1
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146

    same code different report won't work

    I have two buttons one that prints a report based on a Serial Number Field, the other a different report based on the same Serial Number Field. The VBA code is identical except the report to be printed. A pop up window with the Serial Number Field shows up when I am trying to print the second report. I have checked multiple times for any typo's or anything else that is not labeled correctly. I have come to the end of trial and error. Thanks for any assistance.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    reports are sneaky....if the typo (or missing field) is not in the query, then check the report's Grouping.
    sometimes the field is missing but the grouping sort is still there.

  4. #4
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146
    ranman256 thanks so much for the reply. I found the issue. When I built my Query I had the Serial Number field as part of a concatenation but neglected to add the field by itself. I always like the feeling when a problem is figured out.

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

Similar Threads

  1. This code compiles but does not work
    By Lou_Reed in forum Access
    Replies: 6
    Last Post: 10-21-2016, 12:53 PM
  2. Code Does not work
    By larabeelw in forum Access
    Replies: 11
    Last Post: 11-27-2013, 03:18 PM
  3. vba code dont work
    By mikichi in forum Programming
    Replies: 7
    Last Post: 11-12-2013, 01:59 PM
  4. VBA code used to work now it does not
    By rachello89 in forum Programming
    Replies: 9
    Last Post: 06-15-2012, 08:48 AM
  5. VBA Code To Work With MySQL
    By botts121 in forum Programming
    Replies: 0
    Last Post: 07-08-2009, 08:51 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