Creating Stopwatch in Access (1 Viewer)

[omarrr128]

Hi ,

I really need some help as I'm struggling on this. I want to create a stopwatch timer that is on a form for each record.

The form displays a list of jobs which users add their name to. I know how to show the start time but I need a counter next to it in the format 00:00 that shows how long they are on job for from when they click a button.

Ive already searched a lot on google but i cant figure it out. Can anyone help tell me how? Or even create it for me?

Im not at all Good at coding.

Thanks

 

[Gasman]

I would expect it to just be start time subtracted from end time and formatted as you wish?, probably hh:mm ?

From a quick test in the immediate window

tt=now()
? Format(Now()-tt,"hh:mm:ss")

Wait a suitable interval and then press enter on the format line
00:03:24
I used hh:mm:ss format

 

[ebs17]

You can find a stopwatch class here:

Speed tests and speed comparisons for everyone

The attached access file contains two tables, three queries, a module and a stopwatch class. If these elements are transferred to your own application, you will be able to carry out speed tests and speed comparisons for a large number of tasks without great effort. This solution is not as broad...

www.access-programmers.co.uk

 

[omarrr128]

I would expect it to just be start time subtracted from end time and formatted as you wish?, probably hh:mm ?

From a quick test in the immediate window

tt=now()
? Format(Now()-tt,"hh:mm:ss")

Wait a suitable interval and then press enter on the format line
00:03:24
I used hh:mm:ss form

but im very cofused how to integrate this? how do i connect a text box and button to this code?

 

[Gasman]

Well the button executes the calculation using Now()
So if the control is called Duration and the Start Time called StartTime, then ....

Me.Duration = StartTime - Now()
Make the format of the duration control hh:mm or possibly hh:mm:ss
If you want to store it, leave it as a datetime data.

Really depends on how accurate you want it? Would you want to round it to the nearest minute if just using hh:mm ?

 

[isladogs]

See also

Timer Comparison Tests

This article compares 6 different timing methods with a view to determining the reliablility and consistency of each method.

www.isladogs.co.uk

Stopwatch class is included in the example database supplied with that article.
However there are many other equally good, if not better, methods of timing code also included in the article

 

[arnelgp]

see if this is what you need.

 

[omarrr128]

see if this is what you need.

EXACTLY what i need. Thank you so much for taking the time to do it for me. Especially as you made a module I would never have known how to do it. Thank you

 

[omarrr128]

see if this is what you need.

is it possible to make it refresh every minute instead of second? I have tried changing the timer interval on the form properties and in the module but it doesnt seem to change. It will give users time to reconsider their actions like adding jobs or notes or finishing jobs. I dont need the seconds in the timer. If not possible thats okay. Thank you

 

[arnelgp]

1 second for timer = 1000 ms.
multiply it by 60 (for 1 minute)

TimerInterval = 60000

you won' see the changes until 1 minute has passed.

 

[omarrr128]

1 second for timer = 1000 ms.
multiply it by 60 (for 1 minute)

TimerInterval = 60000

you won' see the changes until 1 minute has passed.

thank you for all your help. This worked well but there was a me.requery somewhere else in the code that was confusing but all sorted now