Time Clock Clocking Out

[wjm821]

I have a time clock that works great, except clocking out, it will create another timeclockID. I've searched the forum and the more I see the more I get lost/fustrated on solving the problem.

tblTimeCard
TimeCardID(PK)


EmpID
TimeIn
TimeOut

tblEmployee
EmpID(PK)
EmpName
EmpPosition

frmTimeClock (set to open as new record)
txbUnbound (fills in from login form EmpName) txtEmpName
cmboEmpPosition (EmpPosition, EmpID)
Buttons that fill in date/time for TimeIn and TimeOut
Save Button

How do you open the form to the record with the TimeIN so you can enter the TimeOut instead of creating to TimeCardID's. I did create a query that pulls all the employee's that have not clocked out.

Thank you in advance

[Welshgasman]

You could use DMax() to get the last id for the employee, then FindFirst with that value to get to the record.

[ranman256]

use a form to load the persons ID, and clockout….

get the users last entry rec in query1:
Q1: select ID, MAX(TimeCardID) from table where TimeOut is null and [id]=forms!fMyform!txtID

then update the missing field:

Q2: update table, Q1 set [timeout] = forms!fMyform!txtTimeOut where [id]=forms!fMyform!txtID and table.ID = Q1.ID

[June7]

Since there should be only one record for the employee where TimeOut is null, probably don't need Max()

CurrentDb.Execute "UPDATE tblTimeCard SET TimeOut = Now() WHERE EmpID = " & Me.tbxEmp & " AND TimeOut IS NULL";

Of course, this assumes employee did a proper check in. Could include more code to verify.

[wjm821]

Hate to sound stupid, but where would I put this code. Button to open timecard, onload/onopen timecard? Thank you

[June7]

Open a form where user enters their ID and hours. Have a button with code. Code should include validation to verify ID and hours filled in before trying to save.

What do you mean by you 'have a time clock' - this is just a form in Access?