McSwifty
Registered User.
- Local time
- Tomorrow, 03:22
- Joined
- Jan 14, 2010
- Messages
- 67
Thought I would add my 2 cents here, I have used this for a number of years now and have modified it numerous times to record different info. Really good job on the layout and the reports are superb.
Unfortunately head office liked it too as it made it clear when the time came for people to lose jobs over poor attendance.
I have added a field to record the number of hours away, this also shows on the reports.
I also added the fields for the color coding to the table tblCalInput so I didn't have to do the color in the VBA everytime a new type of leave was added. It's still a bit buggy and can cause issues, but its not too bad.
I will try to remove what I can from the rest of the DB i am using and put up my most recent version for reference.
I even added a shift report so at a glance you can see how each person is doing without having to go through 50-60 people on a regular basis.
I will leave with this warning - mm/dd/yy is standard for SQL dates in VBA when searching and filtering - if you are using dd/mm/yyyy (like me - UK, Australia, NZ and others) you will need to reformat before putting into the VBA and SQL - I simply run
and then use that inline or add a variable to change it over at the start of the VBA code.
I think I mentioned in another poast a while back:
Again Thanks Oxicottin, superb job and I now understand 95% of how and why you did it that way. Great (learning) tool.
Unfortunately head office liked it too as it made it clear when the time came for people to lose jobs over poor attendance.
I have added a field to record the number of hours away, this also shows on the reports.
I also added the fields for the color coding to the table tblCalInput so I didn't have to do the color in the VBA everytime a new type of leave was added. It's still a bit buggy and can cause issues, but its not too bad.
I will try to remove what I can from the rest of the DB i am using and put up my most recent version for reference.
I even added a shift report so at a glance you can see how each person is doing without having to go through 50-60 people on a regular basis.
I will leave with this warning - mm/dd/yy is standard for SQL dates in VBA when searching and filtering - if you are using dd/mm/yyyy (like me - UK, Australia, NZ and others) you will need to reformat before putting into the VBA and SQL - I simply run
Code:
format([datefield],"mm/dd/yyyy")
I think I mentioned in another poast a while back:
Again Thanks Oxicottin, superb job and I now understand 95% of how and why you did it that way. Great (learning) tool.