Thread: Appointment - Event - Holiday Planner Database

Holiday – Appointment – Meeting – Database

Sections Covered.

• Holidays
• Holiday Half Days
• Bereavement
• Sick Days
• Meetings

Reports

• Appointments
• Holiday Detail
• Holiday By Month
• Holiday Summary
• Sickness Summary

The db is primarily for recording holidays, so in order to enter data the employee must exist in the Employee Data Form, but also exist for the Current Year.

In my opinion this was the most logical approach to calculate entitlements correctly and only return data for the specific year on the main form. This is also a benefit as the db will not return staff who may have left the company in previous years. This does not effect the calendar as all entries can be returned regardless of the year.

****IMPORTANT****

There is a issue with the original coding in regards to the Calendar and i’m not much in the mood to try and reinvent the wheel on this, See Below

Private Sub PopulateCalendar()
'strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)
'Use above for non european standards, and comment out duplicate line
strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)

I have made important additions and changes to this sample ,. once i'm done i will upload a new copy. <watch this space>

Db is now working,

Read post 1 carefully if you have any problems.