By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

No events fired Question

P: 48
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
May 23 '08 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 2.5K+
P: 2,545
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...

May 23 '08 #2

P: 48
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.

Ps Il be telling my boss "according to the experts its just not advisable" he he he
May 23 '08 #3

Expert 100+
P: 375
I would say that if the Screen.ActiveControl does not change for some time then nothing is going on.
May 24 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.