I have a need to track the hours I work at work And think it may be of use to others esp if they are a employer.

I have added a task to my version of project manager to list all items I will need to import/edit plus creating a ERD.

All items come from Employee Manager V4

Tables
1.   tblCutOffs
2.   tblShifts
3.   tblNormalHours
4.   tblEmployees "Add ShftID, ColourID, DOB, NINumber Fields"
5.   tblEmployeeOvertimeRates
6.   tblEmployeeRates
7.   tblEmployeeRatesHistory
8.   tblNIRates
9.   tblEmployeeGrades
10.   tblHolidayTypes "Add PayType"
 
Queries Update All
1.   QryTimeSheetDataLimited
2.   QryTimesheetEntry
3.   QryTimesheetFormatedHours
4.   QryTimeSheetLimited
5.   QryTimeSheets
6.   QryEmployeesTimeSheet
7.   QryUpdateMonthDataNull
8.   QryShiftsLookuptList
9.   QryDaysLimetedByWorkingDays
10.   QryEmployeesCombos
11.   QryHolidayChecker
 
Forms
1.   SfrmPreferences Update for Employee Example Items Added
2.   ZfrmCutOffs
3.   ZfrmOvertimeRates
4.   frmTimeSheet
5.   ZfrmTimeSheet
6.   frmAddTime
7.   MsgfrmLoadingData
8.   frmColorSelect1
9.   frmColorSelectSub1
10.   frmDetectIdleTime Add field WorkDays
11.   frmAddTimeWeekly
 
Modules
1.   ModTimesheet
2.   ValidateForm Fuction
 
Update Objects
1.   tblEmployees "Add ShiftID (Long) And ColourID (Long)"
 
 
All EmployeeID Code should be checked for String
Update All calc functions to use Employee Rates

I now Have the time sheet working as normal but have some alteration I need to do to the employees section.
 The Time Sheet


The Time Entry Screen


Preferences (NOTE I I still have some updates I need to do but thay are not needed for the time sheet so will be Including them in another Update)

Added the add multiple Days to timesheet and got it coded, I just need to add in validation like making sure a date hasen't already been added plus data checks.