If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
clocking in and out on jobs
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.. |
#2
|
|||
|
|||
clocking in and out on jobs
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. -- Daryl S "Jana" wrote: 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.. |
Thread Tools | |
Display Modes | |
|
|