DeveloperBarn

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)

Attached Files

Appointment Event Planner.zip (105.9 KB, 80 views)

__________________
If i helped you, make me famous by clicking the

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

__________________
If i helped you, make me famous by clicking the

Hi AOG....

Thanks very much for your help with my Stamps Database...I have been browsing the developerbarn and have found it very informative and interesting, personally I won't be able to help anyone as I am a newbie, but have made an small contribution to help with the expenses in running the board...
Keep up the good work

Carenas

Db is now working,

Read post 1 carefully if you have any problems.

__________________
If i helped you, make me famous by clicking the