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, 209 views)

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

Status: Currently Unemployed - Looking for Work, Can be contacted on thethresher@hotmail.co.uk

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

Status: Currently Unemployed - Looking for Work, Can be contacted on thethresher@hotmail.co.uk

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

Status: Currently Unemployed - Looking for Work, Can be contacted on thethresher@hotmail.co.uk

First of all massive respect, this is fantastic

I've been playing around with this and am having trouble making a couple of minor tweaks.

i) On the right box, named holidays, it has the date, half day, maternity etc etc

What I want is the half day box to be changed to hours taken and then the entitlment recalulated correctly.

So instead of taking a day off entitlement or a half day etc at my company the entitlement is done in hours, eg a person may have 180 hr paid holiday, so it would be good to be able to enter to amount of hour holidays taken.

And...

ii) Not as important, but would be nice, is if a employee tries to book a holiday when there is already 2 off on that day it will come up with a warning message or something similar.

Any tips?