No screen input for 5 minutes

[Ryan]

How do I detect that there has been no user input for e.g.
5 minutes?

I want a special info-form to open when my application has
been idle for some time.

 

[Dirk Goldgar]

How do I detect that there has been no user input for e.g.
5 minutes?

I want a special info-form to open when my application has
been idle for some time.

See this MS KnowledgeBase article for sample code:

http://support.microsoft.com/?kbid=210297
HOW TO: Detect User Idle Time or Inactivity in Access 2000

I don't know if there's a version of the article for later releases of
Access, but the same principles (and probably the same code) apply.

 

[Todd Shillam]

Ryan,

I uploaded to my web server an example of how you can do this with an actual Access 2000 file (it's zipped, so you'll need to uncompress with WinZip or another compression utility). If you need a 97 version, just let me know.

Otherwise, here's the link:

http://sthosting.zapto.org/Technology/Downloads/IdleDetect.zip

You need to create several objects:

2 Forms
1 Macro

Take a look at both form's and their subroutines--you can change the time variables as you see fit. NOTE: To open the demo application and view the database window, press and hold the {Shift} key until fully open.

Good luck,

Todd
How do I detect that there has been no user input for e.g.
5 minutes?

I want a special info-form to open when my application has
been idle for some time.