D
debbie
Hello, I have a timekeeing application in Access 2000 that "they" want
to change. At first there were only a few users, but now there are
more users and somebody has cheated. Right now I have a form pulling
from a table with the following fields:
time_in
time_out
task
job number
The time_in box has a drop down with a list of hours starting at 6:00
a.m. and the time_out is the same way. There were only a few users and
they'd just round up and choose the in and out hours from a dropdown.
Now I have to change it to a "start" button that will record the
current time in the time_in field and when they go to a new record,
it's supposed to automatically record the current time in the time_out
field. I can handle the start time ok, but how do I handle the
automatic posting of the stop time? is it possible? Many thanks in
advance for any ideas.
to change. At first there were only a few users, but now there are
more users and somebody has cheated. Right now I have a form pulling
from a table with the following fields:
time_in
time_out
task
job number
The time_in box has a drop down with a list of hours starting at 6:00
a.m. and the time_out is the same way. There were only a few users and
they'd just round up and choose the in and out hours from a dropdown.
Now I have to change it to a "start" button that will record the
current time in the time_in field and when they go to a new record,
it's supposed to automatically record the current time in the time_out
field. I can handle the start time ok, but how do I handle the
automatic posting of the stop time? is it possible? Many thanks in
advance for any ideas.