Results 1 to 3 of 3
  1. #1
    Dennisol is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    1

    Displaying reports in sequence

    How can I display 5 different reports for 45 seconds each, and then start again in a continuous loop until I want it stopped.
    Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    My first thought is using the timer event of a form. You can use a numeric variable to track which report you're on. If it's empty, you're just starting, open the first. If not, test the number, close that report, open the next and increment the variable. At 5, start back at 1.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Micron is online now Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,369
    I think I would just write a little function using Timer and cause an n seconds pause after each report opening. Close the report, repeat. Easy to alter the duration simply by changing the duration being passed to the function and no extra form needed.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-17-2013, 05:14 AM
  2. Sequence No in order
    By bronson_mech in forum Queries
    Replies: 21
    Last Post: 11-30-2013, 09:16 PM
  3. Replies: 3
    Last Post: 07-29-2012, 04:37 PM
  4. Sequence in Navigation Pan
    By AndreT in forum Access
    Replies: 1
    Last Post: 04-23-2012, 10:04 PM
  5. Error when displaying reports
    By Steve T in forum Reports
    Replies: 1
    Last Post: 07-22-2010, 07:20 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