?
Solved

Skip requery when tab is not active during timer function

Posted on 2011-04-20
2
Medium Priority
?
242 Views
Last Modified: 2012-05-11
I have a mult-tab form.  Each tab contains a form that queries different sets of data.  Each form is set to requery every 5 seconds (on timer me.requery, timerinterval = 5000).  There is a some overhead associated with each of these requery operations.  I would like to only requery the tab that is currently active (on top) and skip the requery if the tab is not active (since it can't be seen).

Is there some way to determine what tab is active from these forms on the tabs?

If so, I can skip the requery if the tab is not active (on top).

Any help will be greatly appreciated.
0
Comment
Question by:compuzak1
  • 2
2 Comments
 

Accepted Solution

by:
compuzak1 earned 0 total points
ID: 35436842
Never mind, I figured it out:

To get the active tab from the forms on the tab:

    If Me.Parent!TabMasterCounts.Value = 5 Then
        Me.Requery
    End If

tabs are numbered 0 (leftmost), 1, 2, ...
0
 

Author Closing Comment

by:compuzak1
ID: 35436845
Figured out the problem on my own
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question