Time Stamp

[jonnymenthol]

Hello,

Can anyone help me please ?

I am attempting to write a database, and am struggling with the following :

1) I want to have a start button and a stop button on my form.
2) When I click Start, I want the current date and time to be stamped in the Start Box, and I want a different box (Duration) to begin counting in minutes and seconds.
3) I want this to continue counting until I press the stop button.
4) Once the stop button is pressed, I want the stop box to be populated with the date and time, and the duration box to show the difference between the start and stop times.

Firstly, is this possible and secondly, would anyone be able to help me with this, as I am fairly new to this, and have had this dumped on me.

Thanks very much in advance.

Jonny.

 

[namliam]

1) Yes its possible and really alltogether not that hard

2) Look into the On timer event of a form.... and see if that gets you anywhere. Try reading about it in the Access help and/or on the forum....

If you have specific questions that you are unable to solve come back here...

Regards

The Mailman

 

[HockeyNut]

You will need to use Coding, and use the Timer control

 

[Mile-O]

Look into the On timer event of a form.... and see if that gets it

NO!!!

Don't count.

If you click Start put the time in the Start Box. Then Click Stop, put the time in the Stop Box. Subtract the Start from the Stop to get the time.

 

[jonnymenthol]

Thanks Very much to you all.

I think I'll go with Mile-O-Phile's idea.

Thanks again.

Jonny.