Reset Form Timer?

[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?

 

[Arvin Meyer [MVP]]

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?

You can do it in code:

Me.TimerInterval = 60000 ' 1 minute

 

[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?

 

[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.