clocking in and out on jobs

[Jana]

Is there a way to set up a program so an employee can clock his jobs he works
on for the day?
Example:
Joe smith is going to work on part 34556, first he types his employee number
then he types the part # 34556 and hits clock in on job. When he is finished
he repeats the above first two steps & and hit clock out of job, then he move
on to the next job..

 

[Daryl S]

Jana -

Yes, you can do this. Set up a table with fields for the employee number,
the part number, a punch time, and an in_out field. You can add an
autonumber field if you want, but you should set up a unique index on the
employee number and punch time.

Set up your form as you described - two unbound fields for employee number
and part number (you can make these drop-lists if you want), and two buttons
for clocking in and out. The code for the click event of the Clock In button
should run an append query which pulls the employee number and part number
from the form, set the punch time to =Now(), and places "In" in the in_out
field. Do the same for a punch out, but set the in_out field to "Out".

You can make this much more complex by testing for matching in/out records,
etc., but this should get you started.