Still here and using this at work on a regular basis. Give it a go and let me know if you have any problems
Dyfink. Missed your post. can't find the files. Must have cleaned it my Google drive and deleted them. I will see if I can find what u did to put the color in the table.
ok, if you change the attendancecode in tblcalinput you also need to change the color details in module basYearView under loadReportCalendar to match those new codes you have in tblcalInput or the calendar view does not display any color markers for the days in question.
the limitation I have found is having hours for one type of leave and days for the other, it would mean two types of tracking data for each staff member. not a big deal but a little more work. I have found hours works pretty well but as Rach wanted days I changed it all over.
The version below is just the standard download by oxicottin and i added the time tracking to it.
Just be aware of the date issue like I put in post #45 if you have system setting to US date format then you won't have any issues, if you do it will take a little bit of work to sort. mostly for the inputbox that comes up when you click on a date for entering data.
This is a great database. I made changes to the colors in the basYearView module and it the colors show on the report, but the form is not showing the colors. The form itself either shows no color or it shows as black.
Can you help me with that?
I am trying to download this database as it's exactly what I have been looking for. Is there any way that you can email it to me? It's still waiting for approval and I want to get started asap. I have to make a few changes to match my leave codes.
When you are able to download I just updated the database to 4.2.... today!
Hi oxicottin,
I found your nice database and like it a lot, the only thing is that I still use access 2003 and would like to be able to make some changes to it. Is there a possibility to get the 2003 version unlocked so I can see how everything works? I want to learn and at the same time create something for my team based on your version.
Any possibility to get the unlocked version would be really great
Thank you and greetings.
FYI - for those without Outlook v15 you may get errors with the code for sending an email and a missing reference in the VBA references. I commented out the code in mod_ShortcutMenuCommands Just comment out Public Function EmailAsPDF() and unticked the reference; at least you can view the database without error then.