Calendars - where to start?

[Fasopus]

So I need to create a calendar to track vacation days for employees. Currently I have a table that stores all the data I should need to make the calendar (employee name, vacation date, ect ect) however Im not sure where to start with actually generating the calendar, isn't this something that Access would have a template for? My boss wants something along the lines of his outlook calendar, I think exporting to an outlook calendar could even be an option but I know nothing about using outlook besides checking email so I'm not sure where to start there either, any suggestions?

PS: I'm using Access 2007 with a database in 2002/2003 format

 

[The_Doc_Man]

Sometimes, Access isn't the right tool for a job and some other tool has already solved the problem. Outlook with a centralized Exchange server is capable of doing something like this. However,...

The trick in building a centralized Access-based calendar like this is to avoid the temptation to build a table with 365 days in it for each year and 366 for leap year. Oh, you can do it, but it is the proverbial "cannon to kill a cockroach" case.

Where you start isn't generating the calendar. It is deciding what you wanted to do with it that counts. Until you know what you REALLY wanted to see, there is no point in building anything. OK, it's a calendar. What's on it? When you view it, what will it look like? What kind of details do you need on it? What functions will it require? Flesh out the problem first, because in ALL programming (not just Access-based), the best solutions work from the problem forward to the solution, not any other way.

In this case the problem is "what you wanted to see/do/track" and the solution is how to see/do/track what you wanted. Start by determining what you want at the end. Work BACKWARDS from that to determine what you must input to have the desired data when you really wanted it. THEN you have the problem definition. From there you can talk about implementation. And not one second before that.

 

[Fasopus]

Ok so I've figured out what I need to happen. I need to have a monthly calendar be displayed. Then I need the calendar to display names in the cells of the applicable days where sombody has taken a vacation day.