Using the Timer in Access XP

[grem629]

I am trying to display a timer that counts down to zero on a form in Microsoft Access. The actual timer would probably be a text box so that you can edit the time. There will be 4 command buttons: Start, Stop, Reset, and Set Time. Also, the time will be put into a field in a record upon another Onclick procedure. I know that I'll probably need some VB code behind it, but any help would be very much appreciated. Thanx in advance.

[tchang]

one more function will be good put a alarm function with yes or no, so when the count down is done it can make some alarm

[Carl-cox-]

what you will need is to set a timer up from the visual basic bit

set the interval to 1000 for 1 second

at teh top of the code write

option explicit  (i think that how you spell it)

Dim count as Integer
timer1.enabled = false
timer1.interval = 1000

inside the timer code put

count = count - 1

to start it with a button just put

timer1.enabled = true

and

timer1.enabled = false

for the stop button

for the reset button just put a value into the count var

 count = 0

and to set time

count = txtbox1.text

also if you want to display it in a txtbox just reverse the code above into the timer

so basically the timer is one big loop that keeps doing the commands inside it every second

im not sure about inputting into a database though

hope this will help