Results 1 to 4 of 4
  1. #1
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071

    Report Paging problem

    I have a complicated Access 2010 Report that pulls data from several different queries. The Report is based on 1 simple query that pulls from a single table. However there are a couple of queries in the Code in the Group footer that pull data and populate controls in the footer. Report has worked fine for several years. I was asked to add some data to the report but they only way I could make it work was to add 2 subreports. Now when I do the print preview the first page is blank and nothing I've done fixes it. I've checked all of the properties and nothing points to a cause. I suspect that the sub reports can be multiple pages which is the cause of this but how can I fix it?

  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,929
    Want to provide db for analysis?
    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
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071
    Quote Originally Posted by June7 View Post
    Want to provide db for analysis?
    Want to but can't it contains data and sharing it would be a HIPAA violation. I exported the problem report to another access DB with no data and tried to attach that but it exceeded the limit of 500K for attachment files. Is there another way to upload it.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Per instructions at bottom of my post, zip with Windows compression.

    Will need data with that report.
    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.

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

Similar Threads

  1. Problem passing line total from sub report to report
    By tbjmobile@gmail.com in forum Reports
    Replies: 9
    Last Post: 02-19-2018, 04:31 AM
  2. Replies: 1
    Last Post: 03-05-2013, 04:05 PM
  3. Report Paging problem
    By newtoAccess in forum Access
    Replies: 4
    Last Post: 11-15-2010, 10:58 AM
  4. Report Problem
    By tlitman09 in forum Reports
    Replies: 0
    Last Post: 02-20-2007, 09:26 PM
  5. Combo Box - Paging Forward / Back
    By neilrpf in forum Forms
    Replies: 0
    Last Post: 03-01-2006, 05:21 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