Solved

Need to auto-requery in Access every x seconds

Posted on 2008-10-13
4
360 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

739 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