Prevent Double "Clock-In"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access Time Clock for employees....Time-In ...Time-Out... Total
Hours Worked. No problem except some guys sign in, forget to sign out and
then sign in again. How can I prevent this?
 
Exactly how you will do it depends on your table structure. Assuming each
clock in creates a new record, you can insert some code where the employee
starts to enter his time that will look to see if he has any previous records
where he signed in but did not sign out:

If Not IsNull(DLookup("[EMP_ID", "TimeTable", "[EMP_ID] = '" &
Me.txtEmployee _
& "' And IsNull [TIME_OUT]") Then
MsgBox = "You did Not Clock Out"
End If

That is only the basic idea, you may want to return a value in the DLookup
and position on the record where he did not clock out to allow him to enter
the clock out info.
 
Thanks

Klatuu said:
Exactly how you will do it depends on your table structure. Assuming each
clock in creates a new record, you can insert some code where the employee
starts to enter his time that will look to see if he has any previous records
where he signed in but did not sign out:

If Not IsNull(DLookup("[EMP_ID", "TimeTable", "[EMP_ID] = '" &
Me.txtEmployee _
& "' And IsNull [TIME_OUT]") Then
MsgBox = "You did Not Clock Out"
End If

That is only the basic idea, you may want to return a value in the DLookup
and position on the record where he did not clock out to allow him to enter
the clock out info.
JJF said:
I have an Access Time Clock for employees....Time-In ...Time-Out... Total
Hours Worked. No problem except some guys sign in, forget to sign out and
then sign in again. How can I prevent this?
Click to expand...
Click to expand...
 
Back
Top