No events fired Question

[panteraboy]

Hi Folks, I was wondering is it possible to return to the user to the opening form if no events are fired for 2 mins. i.e the user is finished so i want the opening screen on when the next user comes in. I know a little about the TimerInterval and getTime methods. but i was wondering how do you tell if nothing has happened for a specific time on a form. Is it possible to do this. Any pointers would be appreciated.

Regards Paul
Paul

[Stewart Ross]

Hi Paul. Although you could set the timer interval to some interval and use the On Timer event to check the value of, say, a global status variable updated within an event handler for the time of the last event I would advise against adopting the approach you are suggesting.

For one thing, there is a very wide range of events to consider, many of them very basic - such as the On Key, Key Up and Key Down events fired for every keypress a user does in a field. For another, you are almost certain to annoy your users (who will end up wanting to use the form at the very moment it times out). And for good measure, what happens when a record is 'dirty' (i.e. has been edited but not stored - you surely don't want to really irritate your users by closing the form in the middle of activity when they just went out for a break...)

I can think of many other reasons not to do it, but instead of listing them suffice to say I just wouldn't go there with this one. That's just my opinion, anyway...

-Stewart

[panteraboy]

Thats what i thought too Stewart. Im just following orders (If that what they be lol". I have my database nearly finished using access 2003 only to find out from my superiors that it is to run on 2007. I Opened it up today only to find over half the functionality doesnt work. How is that for a headache. Is there a big difference in the syntax of vba for 2007 as opposed to 2003.
Regards
Paul

Ps Il be telling my boss "according to the experts its just not advisable" he he he

[RuralGuy]

I would say that if the Screen.ActiveCo ntrol does not change for some time then nothing is going on.