Time Sheet

[itsalesguru]

I started off to make a simple time sheet for our small firm employees to records their in and out time.

associateDetailstbl. contain all the information with all their contact info. AssociateID is the primary key

then made a table query of above table to capture primary key, first and last name, called the new table NAMEtbl

in another table, timesheettable have timeDI, assosictaeID, Date, time in, break time out, break time in, time out.
then made a qry from NAMEtbl and TimeSheettbal called namesource qry that contains associateID from both tables, fist name and last name, used this as a source for a form. then made a subform from timesheet and inserted in this form. I also put a button on the subform that makes new record, when it is pressed all the fields in subfor clears for new record but not the information on the form that is actually just first name combo box that autofill the last name text box/

that am I missing here? I also want for staff to be able to go back to theri entries for the day and enter the data for later time of the day like time out??

I apprecite in anyone can help,

 

[John Big Booty]

Check out the templates within Access, also check the templates available here, there may be other sources on line as well.

Whilst you may not find exactly what you are looking for you might find a template that does something similar that you can get some ideas from, and implement in your own design, or simply modify the one that most closely matches your requirements.