TimeClock

[A real begineer]

I have been asked to add a timeclock function to my forms. I had a look at a few books and have only found a reference to a timer control in VB 6.0 which does not appear to be available in VBA. I need the timeclock to run continuously regardless of events or non events on screen and when a pre set time is reached beep and open a form. I can see how to do this in response to an event, however, I am worried about looping as I think I could end up in a unfinishing loop.

Any suggestions are appreciated.

 

[llkhoutx]

Each form has a OnTimer event controllable via VBA. It's near the end of the Form property list.

Note that the Timer Interval (also a form property) is limited to 2,147,483,647 milliseconds in Access 97.

 

[Chris RR]

Microsoft has a knowledge base article that shows how to detect user idle time. It might be a start, since you want to detect time whether the user was idle or not.

Go to http://search.support.microsoft.com/kb/c.asp

and look for article Q210297, "ACC2000: How to Detect User Idle Time or Inactivity"

 

[ntp]

Create a form and remove the close button, max,min buttons so the user can't close it. Set it's Timer interval to some amount of milliseconds. Write an ontimer event to open the form.
As for the limit llkhoutx spoke about, I'm pretty sure that is enough time, unless you are going to have the app open for days on end (24 days max).
When the app is opened you wil lwant to load the timer form and Hide (use Hide property of form I believe) it.

ntp

 

[A real begineer]

Thanks for the replies I will try your suggestions.