Reset Form Timer?

M

martinmike2

Hello,

is it possible to reset a form timer if the user is actively using the
db? If not, is it possible to mimic the effect in code?
 
A

Arvin Meyer [MVP]

martinmike2 said:
Hello,

is it possible to reset a form timer if the user is actively using the
db? If not, is it possible to mimic the effect in code?
Click to expand...

You can do it in code:

Me.TimerInterval = 60000 ' 1 minute
 
M

martinmike2

ok, thanks for that. Is there a flag I can set or something to watch
for user action? Or do I have to add that line to every concievable
action the user would take?
 
A

Arvin Meyer [MVP]

Since Windows is an event based computing model, you'd have to set a flag
either on control events or form events. The Timer event is a form level
event. As is the Dirty event (fires with first keystroke in a control) and
the Before and After Update events. There are also keystroke and mouse
events for the form and individual controls, as well as for sections (like
the Detail Section or a Footer) of the form. So you can use one of these
events to monitor actions.
 
Top