MajP
You've got your good things, and you've got mine.
- Local time
- Today, 09:32
- Joined
- May 21, 2018
- Messages
- 9,379
In response to
Here is a properly designed attendance tracker with a few bells and whistles. It allows you to color code one or more attendance codes for a given dates. This uses color codes stored in the attendance code table and then uses rich formatting to wrap the attendance code. Obviously without the color coding and multiple events per day this would be even simpler.
The data is entered in a normalized format.
ex
tbl_Attendance tbl_Attendance
In this case you can have more than one absence code for a given day and assign an amount of time.
There are currently two working views. One view you can pick an employee and assign all of their absences for a given year. The other shows all the employees and you can assign absences for a given month.
In the image below the Year view is shown over the month view for employee Chad Zebra for the month of March.
You can see on 24 march on both calendars there are two absence codes.
The two calendars basically use the same code to format the dates. There are only slight modifications.
If you do not like the format you can modify it easily, but the code should be pretty reusable.
If looking for other trackers, calendars, or calendar controls see
Attendance by days name of week and correspond date/Month
Hi, I have an Excel sheet for recording attendance, and I would like to replicate format in MS Access. However, I'm not sure how to proceed with creating it. Essentially, I want to be able to select the year and month, and then have the days of the week and corresponding dates automatically...
www.access-programmers.co.uk
Here is a properly designed attendance tracker with a few bells and whistles. It allows you to color code one or more attendance codes for a given dates. This uses color codes stored in the attendance code table and then uses rich formatting to wrap the attendance code. Obviously without the color coding and multiple events per day this would be even simpler.
The data is entered in a normalized format.
ex
tbl_Attendance tbl_Attendance
| AttendanceID | AbsenceDate | EmployeeID | AbsenceID | AbsenceTime | AbsenceReason |
|---|---|---|---|---|---|
169 | 5/1/2024 | 3 | 2 | 8.00 | Personal Day |
177 | 5/2/2024 | 3 | 4 | 8.00 | Called in at 4:30am and left a message stating he needed a FMLA day due to his sinus issues and a doctor appointment. |
184 | 5/2/2024 | 3 | 1 | 6.50 | Bobs wife called several times about the smell of a natural gas leak smell in the house. Bob left at 7:30pm |
191 | 5/3/2024 | 3 | 2 | 10.00 | Personal Holiday |
194 | 5/3/2024 | 3 | 17 | 8.00 | Vacation |
218 | 1/4/2024 | 3 | 1 | 2.00 | In Trouble |
219 | 2/5/2024 | 3 | 19 | 1.00 | Smoking dope |
220 | 3/6/2024 | 3 | 6 | 12.00 | Jury duty |
225 | 1/1/2024 | 3 | 1 | 1.00 | Sick |
226 | 1/1/2024 | 3 | 4 | 2.00 | death |
227 | 9/2/2024 | 3 | 20 | 4.00 | Test |
228 | 3/2/2024 | 3 | 16 | 5.00 | Test |
229 | 3/3/2024 | 3 | 5 | 5.00 | Test |
231 | 2/1/2024 | 3 | 1 | 5.00 | Bad |
232 | 2/1/2024 | 3 | 2 | 3.00 | Excused |
248 | 5/1/2024 | 3 | 4 | 2.00 | Death in family |
There are currently two working views. One view you can pick an employee and assign all of their absences for a given year. The other shows all the employees and you can assign absences for a given month.
In the image below the Year view is shown over the month view for employee Chad Zebra for the month of March.
You can see on 24 march on both calendars there are two absence codes.
The two calendars basically use the same code to format the dates. There are only slight modifications.
If you do not like the format you can modify it easily, but the code should be pretty reusable.
If looking for other trackers, calendars, or calendar controls see
Date Pickers, Calendar Controls, and Calendar resources
There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...
www.access-programmers.co.uk
Last edited:
