Time start/end button

K

KLP

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
 
R

Rick Brandt

KLP said:
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
Click to expand...

Code for each button's Click event...

Me.SomeControlName = Now()
 
T

Tom Lake

KLP said:
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,
Click to expand...

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
 
K

Keith Wilby

KLP said:
I have a need to multiple start and end times during the day.
Click to expand...

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
 
Top