Solved

Need to auto-requery in Access every x seconds

Posted on 2008-10-13
4
349 Views
Last Modified: 2012-05-05
Hello experts,
I have a button in MS Access does the following

List2.Requery

Is there some way I can have this operation happen every x seconds ?

Thanks
0
Comment
Question by:Mannsi
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
Jupiler78 earned 500 total points
ID: 22700940
Hello Mannsi,

On the form set the Timer Interval as wanted.
Then in the Timer event of the form: List2.Requery

Regards,

Jupiler78
0
 

Author Comment

by:Mannsi
ID: 22700989
Thanks, that will be most helpful.
Is the Timer Interval measured in secods ?
0
 
LVL 8

Expert Comment

by:Jupiler78
ID: 22700996
No, in miliseconds
0
 

Author Closing Comment

by:Mannsi
ID: 31505553
Thanks
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

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