Time Log In/Out

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

Guest

Any ideas on how to create a screen where students can type in their ID and click the LOG IN button to record their time in and then type in their ID and click the LOG OUT button to record their time out. The problem I am having is how to tell it to go back and record the TIME OUT in the correct record with the corresponding TIME IN. I hope that makes sense.
 
You must lookup the entry in the table.

You will have to use the DLookup function.

HELP should explain it to you.

Rick B


Any ideas on how to create a screen where students can type in their ID and
click the LOG IN button to record their time in and then type in their ID
and click the LOG OUT button to record their time out. The problem I am
having is how to tell it to go back and record the TIME OUT in the correct
record with the corresponding TIME IN. I hope that makes sense.
 
When the student logs in, store their ID in some global
variable, and then when the student wants to logout, you
could issue a SQL Update statement where you would set the
LOGOUT date/time to the current date/time using the Now()
function, WHERE the ID field equals the currently logged
in student's ID in that global variable.

-----Original Message-----
Any ideas on how to create a screen where students can
Click to expand...
type in their ID and click the LOG IN button to record
their time in and then type in their ID and click the LOG
OUT button to record their time out. The problem I am
having is how to tell it to go back and record the TIME
OUT in the correct record with the corresponding TIME IN.
I hope that makes sense.
 
Back
Top