Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Need to auto-requery in Access every x seconds

Posted on 2008-10-13
4
Medium Priority
?
395 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 2000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses

886 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