I am presently trying to setup a Check In - Check Out system for a factory with about 100 employees to replace the old time-punching machine. I put barcoded stickers onto the old time cards. The old time-punching machine will be replaced by a computer that runs only a Access mde ap. An employee checks in or out by taking his time-card and place the barcode under a barcode scanner that immediately reads the employee ID and the form records the time. There are 2 barcodes, one for IN and one for OUT, placed on each side of the card, so that no mouse or keyboard is required. There will be no error messages shown, all errors will be handled on a saparate computer. Data is stored in a table with the following fields:
WorkDate
EmployeeID
Status (IN or OUT)
CheckTime
To deal with possible errors the office staff will have to import the records into a form the next day for inspection and do necessary adjustments before updating to the EmployeeWorkHours table which stores WorkDate, EmployeeID and HoursWorked.
There are possible errors I must be prepared to deal with. A worker might scan the card twice, or scan the OUT bacode while checking IN, etc. Also, an employee might leave work later in the morning and come back to work again in the afternoon, but scans only 3 times. I am using 3 queries to import the data into the InspectionForm, one draws the Check-In times, one draws the Check-Out times, and one (see attached image file) combines the two queries into one which shows:
WorkDate
EmployeeID
CheckInTime
CheckOutTime
The problem with this query is that if an employee who works 2 sessions forgets to check once it still shows 2 complete IN & OUT records. This though is not a critical problem but it's not easily recognised. I would appreciate if anyone can suggest a easy way so that a missed check time would display as blank in this case, e.g.:
Workdate EmployeeID CheckIn CheckOut
10/8/04 ----- 34 ----- 8:00 am - 11:00 am
10/8/04 ----- 34 ----- (blank) -- 4:30 pm
Peter
WorkDate
EmployeeID
Status (IN or OUT)
CheckTime
To deal with possible errors the office staff will have to import the records into a form the next day for inspection and do necessary adjustments before updating to the EmployeeWorkHours table which stores WorkDate, EmployeeID and HoursWorked.
There are possible errors I must be prepared to deal with. A worker might scan the card twice, or scan the OUT bacode while checking IN, etc. Also, an employee might leave work later in the morning and come back to work again in the afternoon, but scans only 3 times. I am using 3 queries to import the data into the InspectionForm, one draws the Check-In times, one draws the Check-Out times, and one (see attached image file) combines the two queries into one which shows:
WorkDate
EmployeeID
CheckInTime
CheckOutTime
The problem with this query is that if an employee who works 2 sessions forgets to check once it still shows 2 complete IN & OUT records. This though is not a critical problem but it's not easily recognised. I would appreciate if anyone can suggest a easy way so that a missed check time would display as blank in this case, e.g.:
Workdate EmployeeID CheckIn CheckOut
10/8/04 ----- 34 ----- 8:00 am - 11:00 am
10/8/04 ----- 34 ----- (blank) -- 4:30 pm
Peter
