Timeclock

[Pvarga]

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

 

[Rob.Mills]

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.

 

[Pvarga]

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

 

[jawilli1]

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....

 

[Pauldohert]

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