Start and Stop Button to the current running hours.

[Jeremy Sng]

Hi i'm currently creating running hours which it's currently run 24/7. But i wish to create a start and stop button because the system will stop when i do servicing. Which i can easily tracks my downtime. Any one can help me. Thanks

[ranman256]

in a form click the start timer ,this sets the start variable

a text box for start , stop and elaps

sub btnStart_click()
txtStart = now()
end sub



sub btnStop_click()
txtEnd=now()
txtElaps =DateDiff("n",txtStart, txtEnd)

'run a query to post txtElaps to a table
end sub

theres also the TOGGLE button, pressed in , timer can be on
press again, it turns off and the timer.

[Jeremy Sng]

Will this works when i already calculate on Query?