+ Reply to Thread
Results 1 to 6 of 6

Thread: Appointment - Event - Holiday Planner Database

  1. #1
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    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)
    Attached Files
    Last edited by AOG123; February 9th, 2009 at 08:02 AM.
    If i helped you, make me famous by clicking the

  2. #2
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    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

  3. #3
    Barn Newbie Carenas is on a distinguished road Carenas's Avatar
    Join Date
    Jan 2009
    Posts
    8
    Rep Power
    4

    Insert a Picture

    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

  4. #4
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    Db is now working,

    Read post 1 carefully if you have any problems.
    If i helped you, make me famous by clicking the

  5. #5
    Barn Newbie jj72uk is an unknown quantity at this point jj72uk's Avatar
    Join Date
    Aug 2009
    Posts
    1
    Rep Power
    3

    Little tweak

    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?

  6. #6
    Barn Newbie mars is an unknown quantity at this point mars's Avatar
    Join Date
    Jul 2009
    Posts
    4
    Rep Power
    3

    Ive downloaded your sample. Great job. Looks really neat. Thank you very much for putting this sample on here. Its excellent

+ Reply to Thread

Similar Threads

  1. VBA Code on an On Click Event Procedure
    By CushingMT in forum Microsoft Access
    Replies: 5
    Last Post: December 18th, 2008, 08:05 AM
  2. On onchange event hide blank frame
    By guddu in forum JavaScript Programming
    Replies: 3
    Last Post: September 8th, 2008, 10:14 AM
  3. Grouping buttons to one event
    By Shem in forum .NET Development
    Replies: 8
    Last Post: July 17th, 2008, 07:53 AM
  4. adding an event for my btnDelete in repeater
    By Shem in forum .NET Development
    Replies: 13
    Last Post: July 15th, 2008, 10:33 AM
  5. addLoadListener - adding onload event in generic way
    By Shadow Wizard in forum JavaScript Code Samples
    Replies: 0
    Last Post: July 13th, 2008, 02:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO