Timeclock

Pvarga

Registered User.
Local time
Today, 00:52
Joined
Apr 6, 2002
Messages
50
I would like to make a database that is used to sign in and out so the amnount of tim spent in a lab can be tracked.

I had some good beginnings but am confused about how to make sure someone has signed in before they sign out.

Thanks
 
You can setup a table to keep track of this. Then create a form to open on startup that asks for a user id and when they close that form it would add a record to the table that gives a time stamp.
 
How do I seperate in and out?
Is there a way to pop up a mesage if they click sign out and have not signed in?

What about more thanonce ina day?

thanks for your response
 
I recommend keeping the sign-in/sign-out values in pairs so they will occur in the same record. If your input is coming from a time clock so that these events generate separate transactions, the processing is much more difficult. When someone signs in, you need to look for a log record for their ID with the SignOut field being null. If that is the case, there is an error because they are trying to sign in again without first signing out. Do something to handle the error and give them the option of saying "oops", I really ment to sign out. You do the same thing whey they say they want to sign out except that in this case, finding a row is good and not finding one is bad.
 
Did you ever get a working application? Can you post a sample of what you did. I'm running into some major problems with this exact topic....
 
Can anyone recommend a well priced (cheap) swipe timeclock that is easy to work with a database - SQL SERVER.

How much work is required to get basic in and out times each day for a employee record on the database?

Thanks Paul
 

Users who are viewing this thread

Back
Top Bottom