Database to Track Employees' Scheduled Time Off

[timorrill]

I am creating a database that will allow employees to enter scheduled time
off (vacation, etc.) and allow management to assign work accordingly.

When a manager clicks an employee's name, I would like a calendar (monthly
view) to pop up, populated with the entries that the employee has provided.

Are there any ideas about how to create this type of calendar, and how to
set up the coding to populate it with entries?

Here's an example. Suppose John Doe enters a scheduled vacation day on
January 1, 2007, for 8 hours. When a manager clicks John's name, the manager
should see a pop up window with a montly view of the current month. The
manager should then be able to select January 2007 and see the month of
January. On Jan 1, there would be an entry that says "8 - Vacation".

The calendar control in Access allows for most of this functionality (i.e.,
allowing the user to select different months and years, etc.), but I don't
think I can write anything to individual dates.

I welcome all suggestions and ideas!

Thanks!

 

[Barry Gilbert]

I've used a calendar control called ctSchedule quite a bit:

http://www.dbi-tech.com/Product_Page_Solutions_Schedule.htm

It takes some work to interact with it, but it is very feature-rich.

Barry

 

[Peter Hibbs]

If you are happy to do a bit of VBA coding I suggest you try a Flex Grid
control. There is a Flex Grid Demonstration database at :-

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

which does more or less what you want and could be easily modified.