Results 1 to 4 of 4
  1. #1
    JustMike is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2018
    Posts
    7

    Open Multiple Reports with a Button

    I have a database that has 4 reports. I would like a button on the switchboard that opens all 4 at the same time. Can anyone help? Thank you so much!

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What is the code you use to open 1 report? What have you tried?

    Use the same code to open the next 3 reports....
    Something like
    Code:
    Sub Button1_Click()
       DoCmd.OpenReport "Report1"
       DoCmd.OpenReport "ThisReport"
       DoCmd.OpenReport "ThatReport"
       DoCmd.OpenReport "AnotherReport"
    End Sub
    This will cause the reports to be printed.

    If you want to preview each report, use
    Code:
    Sub Button1_Click()
       DoCmd.OpenReport "Report1", acViewPreview
       DoCmd.OpenReport "ThisReport", acViewPreview
       DoCmd.OpenReport "ThatReport",acViewPreview
       DoCmd.OpenReport "AnotherReport", acViewPreview
    End Sub

  3. #3
    JustMike is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2018
    Posts
    7
    I use the switchboard to open the one form. How/Where do I put this?

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I don't use the switchboard - never have. It is too confining.

    You state you have a button to open the report. Do you know how to look at the code for the button?

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

Similar Threads

  1. Replies: 13
    Last Post: 02-08-2017, 04:11 PM
  2. calling multiple reports from single form button
    By lugnutmonkey in forum Reports
    Replies: 3
    Last Post: 01-02-2013, 02:28 PM
  3. Replies: 4
    Last Post: 09-09-2011, 06:11 AM
  4. Replies: 3
    Last Post: 05-23-2011, 01:52 PM
  5. Replies: 1
    Last Post: 07-02-2010, 03:55 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