Results 1 to 2 of 2
  1. #1
    detjo is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    1

    Different reports open in same window

    Hi All

    On a form I have a button that runs a macro. The macro opens 15 different reports, but the only way i could get it to work was to have each report open in its own window (up to 15 report windows stacked on top of each other!).
    The problem with this is, if they need printing, each report is sent to the printer as a single page - so the printer lists all 15 reports as a separate print job meaning each 'job' has to be released instead of just one job printing all 15 pages. Sooo much slower and a PITA

    Is there a way to get all 15 reports to open in the same window?

    - Each of the 15 reports has its own report template as they are all different
    - It would be better for me if this could be done in a macro as i know nothing about VBA
    - If it has to be done in VBA i'm willing to give it a go, but i'll prob need comments included so i can see exactly what is doing what etc.



    I appreciate yur time and help and thanks in advance!

    - - - - - - - - - - - - -

    detjo

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    As far as I know each report is distinct and can't 'share' window. Might be able to code a custom 'Print All' button that would print all open reports. This is customization of ribbon and QAT (quick access toolbar). When I did button/ribbon customization in a 2007 project, required HTML code in a special table called USysRibbons. If you are still interested, check out http://forums.aspfree.com/microsoft-...at-303789.html

    Alternatively, send reports direct to printer.
    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. Replies: 4
    Last Post: 09-13-2011, 03:16 AM
  2. Replies: 4
    Last Post: 09-09-2011, 06:11 AM
  3. How to open form in a window, not maximized ?
    By peshonzi in forum Access
    Replies: 4
    Last Post: 07-07-2011, 06:52 AM
  4. Open Outlook window but don't send
    By Paul Taylor in forum Access
    Replies: 2
    Last Post: 04-07-2011, 11:51 AM
  5. Reports w/ sub-reports very slow to open
    By vaikz in forum Reports
    Replies: 2
    Last Post: 02-27-2011, 08:41 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