DD's Stats

Members
Total Members: 157
Latest: irsmalik
New This Month: 7
New This Week: 0
New Today: 0
Stats
Total Posts: 876
Total Topics: 444
Most Online Today: 4
Most Online Ever: 52
(May 02, 2020, 05:24:19 pm)
Users Online
Members: 0
Guests: 2
Total: 2

Recommended Posts

DD Approved Members group Added by DD Admin
05-06-2020, 12:48:35


Posting Additions or alterations rules by DD Admin
27-02-2020, 10:33:01


A Trip Down Memory Lane by DD Admin
24-08-2019, 14:17:16


Todays Birthdays

DD's Top Posters

DD Admin
Posts: 910
borobutch
Posts: 69
Carol
Posts: 12
Ram
Posts: 8
Clarissa
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

Author Topic: Timesheet  (Read 208 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Timesheet
« on: March 19, 2020, 09:14:23 pm »
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
« Last Edit: March 24, 2020, 01:07:54 pm by Michael »

Share on Facebook Share on Twitter


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Timesheet
« Reply #1 on: March 20, 2020, 05:43:26 pm »
I have started an update while I'm adding the timesheet

1350-0
« Last Edit: March 20, 2020, 05:48:47 pm by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Timesheet
« Reply #2 on: March 21, 2020, 03:04:43 pm »
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)
« Last Edit: March 21, 2020, 03:07:43 pm by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Timesheet
« Reply #3 on: March 22, 2020, 08:15:23 pm »
I will be uploading a new version in the next few days that includs all timesheet, Employees and wages updates.


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Timesheet
« Reply #4 on: March 23, 2020, 09:52:18 pm »
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.


 

Related Topics

  Subject / Started by Replies Last post
0 Replies
15 Views
Last post April 04, 2020, 01:54:17 pm
by DD Admin
0 Replies
11 Views
Last post April 04, 2020, 03:42:30 pm
by DD Admin

DD's Social Media

DD's Programs


Development Schedule

DD's Freeware

Apollo

DJ 2020

Chart Tracker Elite

Works Manager

Contact Manager

Simple Home Accounts

Book Library

Picture Library

Project Manager (accde)


Developer Tools

Project Manager (accdb)

Style Manager

Code Library


Open Code Templates

Master Template

Task Management

Charitable Contributions

Bug Tracker Template

Time And Billing Template

Real Estate Template

Household Inventory V1


Open Code Examples

DD's Northwind V1

Employee Example V5

Grid Demo Example V1

Employee Example V4

Small Examples


Recent Topics

Apollo Project Status by DD Admin
January 15, 2021, 11:00:15 am

Apollo Manual: Main Music Player by DD Admin
January 13, 2021, 10:21:36 am

UK Singles/Albums Charts 01 Jan 2021 to 07 Jan 2021 Analysis by borobutch
January 11, 2021, 09:27:29 pm

Please welcome irsmalik to DD by DD Admin
January 11, 2021, 09:34:58 am

Please welcome FamiliaRoca to DD by DD Admin
January 11, 2021, 07:49:40 am

Please welcome Gasman to DD by DD Admin
January 10, 2021, 02:01:23 pm

Please welcome ferrancc to DD by DD Admin
January 09, 2021, 06:21:49 pm

Database Dreams is not affiliated with Microsoft