Results 1 to 3 of 3
  1. #1
    SFC is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    47

    Report runs until reopened

    Click image for larger version. 

Name:	ACCESS REPORT 1.jpg 
Views:	11 
Size:	18.9 KB 
ID:	8904I get this dialog box when printing my report as it reaches the Report Footer and I cannot print the last page that has the report footer. If I add a field from the field list to my report footer this dialog will not show and I can print the footer page. Once I save and close the file, then reopen it again, I get this dialog box.



    Any suggestions are greatly appreciated.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Never seen that. Would have to examine the db. If you want to provide, follow instructions at bottom of my post.

    Is there code associated with the footer? Have you step debugged? Review link at bottom of my post for debugging techniques.
    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
    SFC is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    47
    Funny, right when I got your email that you replied to my post, I found the solution. I had a macro in my Report footer to hide a filed if it was zero. I cut the macro from the Report footer and pasted it into the Page footer and it works fine. Which I guess makes scense because the last page is where the macro takes fuctions anyway.

    Thanks for taking the time to reply to my post.

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

Similar Threads

  1. Query runs fine but report doesnt work
    By endri81 in forum Queries
    Replies: 4
    Last Post: 04-28-2012, 02:35 PM
  2. Background runs beyond end of page
    By BigCat in forum Reports
    Replies: 0
    Last Post: 06-14-2011, 08:02 AM
  3. Database that runs macros in another DB
    By BED in forum Programming
    Replies: 1
    Last Post: 10-01-2010, 11:20 PM
  4. Exception When Executing In Java But Runs In MS Access DB Manually
    By vasuresh.kishor@gmail.com in forum Access
    Replies: 0
    Last Post: 03-11-2010, 12:22 AM
  5. Form that runs query and creates reports
    By Valeda in forum Forms
    Replies: 2
    Last Post: 05-04-2006, 07:01 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