Prev: I need to populate a sub-form field from the original form
Next: Alternate row color for combo box
From: robboll on 14 May 2010 22:06
I am able to create the stopwatch form at: http://support.microsoft.com/kb/325238

What I am trying to do is the same, except it is on a continuous
form. So if it is a task form and there are five tasks, each form
would have a seperate stopwatch, to include a bound field for the
ElapsedTime. The idea is to record each time spend on each task.

Continuous Form Problem: When I click on 'Start' for the first record
(Task 1) the ElapsedTime begins as expected. When I click 'Stop' the
ElapsedTime stops as expected and is correct.

When I click 'Start' for the second record (Task 2) the ElapsedTime
starts at the time where Task 1 left off. Is there a way to make the
timer in Task 2 is not influenced by Task 1?

Appreciate any help with this.

Thank you!

RBollinger
From: Tom van Stiphout on 15 May 2010 01:32
On Fri, 14 May 2010 19:06:23 -0700 (PDT), robboll
<robboll(a)hotmail.com> wrote:

Even if that were possible, in the general case you can't spawn as
many timer as you would like. I believe the max is 16, but I may be
mistaken. Anyway, can you think of a way to deal with this using a
single timer?

-Tom.
Microsoft Access MVP


>I am able to create the stopwatch form at: http://support.microsoft.com/kb/325238
>
>What I am trying to do is the same, except it is on a continuous
>form. So if it is a task form and there are five tasks, each form
>would have a seperate stopwatch, to include a bound field for the
>ElapsedTime. The idea is to record each time spend on each task.
>
>Continuous Form Problem: When I click on 'Start' for the first record
>(Task 1) the ElapsedTime begins as expected. When I click 'Stop' the
>ElapsedTime stops as expected and is correct.
>
>When I click 'Start' for the second record (Task 2) the ElapsedTime
>starts at the time where Task 1 left off. Is there a way to make the
>timer in Task 2 is not influenced by Task 1?
>
>Appreciate any help with this.
>
>Thank you!
>
>RBollinger
From: Arvin Meyer [MVP] on 16 May 2010 21:46
The problem with a continuous form is that each task is in the same text
box, so that what you see is the same timer. If you had 5 different fields,
you could make it work, but then, of course your database wouldn't be
normalized.

One possible solution is to create a Stopwatch on an unbound textbox,
similar to the one on my website:

http://www.datastrat.com/Download/StopWatch2K.zip

Then in the restart button, write the elapsed time to your text field before
resetting the time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"robboll" <robboll(a)hotmail.com> wrote in message
news:4d9ffe32-98a7-4f8d-befb-2509226403c5(a)p17g2000vbe.googlegroups.com...
>I am able to create the stopwatch form at:
>http://support.microsoft.com/kb/325238
>
> What I am trying to do is the same, except it is on a continuous
> form. So if it is a task form and there are five tasks, each form
> would have a seperate stopwatch, to include a bound field for the
> ElapsedTime. The idea is to record each time spend on each task.
>
> Continuous Form Problem: When I click on 'Start' for the first record
> (Task 1) the ElapsedTime begins as expected. When I click 'Stop' the
> ElapsedTime stops as expected and is correct.
>
> When I click 'Start' for the second record (Task 2) the ElapsedTime
> starts at the time where Task 1 left off. Is there a way to make the
> timer in Task 2 is not influenced by Task 1?
>
> Appreciate any help with this.
>
> Thank you!
>
> RBollinger


 | 
Pages: 1
Prev: I need to populate a sub-form field from the original form
Next: Alternate row color for combo box