Time start/end button

[Guest]

Is it possible to have on a form a start and end time button. The users
clicks START and the time is recorded, they click END and that time is
recorded. I have a need to multiple start and end times during the day.

If this is possible, could you point me in the right direction?
Thank you,

Kelvin

 

[Rick Brandt]

Is it possible to have on a form a start and end time button. The
users clicks START and the time is recorded, they click END and that
time is recorded. I have a need to multiple start and end times
during the day.

If this is possible, could you point me in the right direction?
Thank you,

Kelvin

Code for each button's Click event...

Me.SomeControlName = Now()

 

[Tom Lake]

Is it possible to have on a form a start and end time button. The users
clicks START and the time is recorded, they click END and that time is
recorded. I have a need to multiple start and end times during the day.

If this is possible, could you point me in the right direction?
Thank you,

In addition to Rick's advice, you could use just one button for both.
Click it and, if the start time isn't filled in, fill it in. Click it again
and the end time is filled in. You could also toggle the caption to
read "Start" when the button will save the start time and "End"
when the button is set to record the end time. Of course, this
is assuming you only want to record one start/end pair at a time.
If you're keeping track of multiple times, this won't work.

Tom Lake

 

[Keith Wilby]

I have a need to multiple start and end times during the day.

Do you want multiple start/finish instances per record? What's your aim?
Also, have you considered mitigating for illogical operations such as
clicking "stop" without having clicked "start", or clicking them in the
wrong order?

Just a thought or two.

Keith.
www.keithwilby.com