Results 1 to 2 of 2
  1. #1
    RMittelman is offline Advanced
    Windows 10 Access 2016
    Join Date
    Dec 2010
    Simi Valley, CA

    Open Multiple Report Instances

    In my application, I have several reports which are derived from the same report definition. For example: Audit Report, Audit Refund Report, Audit Report Without Refunds.

    Each of these is derived from a report definition called "AuditReport". It's definitely more efficient to only maintain 1 report rather than 3, right? The report is based on a query, which I modify a parameter in just before loading the report. That parameter is an integer (-1, 0 or 1). The stored procedure behind this passthrough query knows how to handle the parameter and only return the specific rows (credits only, debits only or all).

    So far, everything is working fine, the report versions come up properly in print preview mode. The problem is when the customer wants to open all 3 of them at the same time (they appear as tabs in the Access UI) so they can compare them. Since they're based on the same report definition, if I try to run the second version Access simply switches to the first version of the report, since it thinks I'm asking for the same thing again. I have to close the report before opening another version of it.

    Easiest thing would be to define multiple report definitions and things would work just fine. But is there any way to open a second (different) version of the report at the same time? Seems like that would keep the database cleaner.


  2. #2
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    From your description you are talking about multiple instances of a report which is perfectly doable. google something like 'access vba open multiple instances of a report' to find plenty of links.

    see post #4 of this link for an example

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

Similar Threads

  1. Multiple Instances of the same table in one query
    By in forum Queries
    Replies: 21
    Last Post: 06-20-2019, 01:25 PM
  2. run multiple instances of the same database
    By chriswrcg in forum Access
    Replies: 1
    Last Post: 05-08-2019, 07:03 AM
  3. Unique ID for Multiple Form Instances
    By mblevins in forum Database Design
    Replies: 2
    Last Post: 10-31-2013, 04:01 PM
  4. Counting instances across multiple tables
    By New_2_Access in forum Queries
    Replies: 1
    Last Post: 07-19-2012, 04:47 PM
  5. Multiple Payment Instances
    By luckysarea in forum Queries
    Replies: 3
    Last Post: 04-21-2011, 03:29 PM

Tags for this Thread

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 - Senior Forums