Results 1 to 3 of 3
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591

    Closing multiple reports


    I'm not sure why this wouldn't work, but it only closes the first report then exits the loop.
    Code:
        For Each Report In Reports
            DoCmd.Close acReport, Report.Name, acSaveNo
        Next

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Do you have only 2 reports open? This might have explanation http://www.techrepublic.com/blog/mso...-database/1662
    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
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    That's it exactly!

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

Similar Threads

  1. Multiple Sub Reports
    By Top Fuel Friday in forum Reports
    Replies: 8
    Last Post: 02-17-2014, 11:37 AM
  2. Multiple Reports to Single PDF
    By hkimpact in forum Access
    Replies: 1
    Last Post: 06-11-2012, 03:17 PM
  3. Replies: 5
    Last Post: 01-18-2012, 03:46 PM
  4. Multiple Queries and Reports
    By Chad E in forum Access
    Replies: 4
    Last Post: 10-18-2011, 01:47 PM
  5. Multiple Reports in email
    By Madmax in forum Reports
    Replies: 3
    Last Post: 09-26-2011, 11:05 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