X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Employee Vacation Request Calendar    
post Sep 3 2003, 10:31 AM

Posts: 667
Joined: 7-November 01
From: Arizona

Attached is a yearly calendar that shows requests for vacation days. It will not allow more than 3 people to request the same day off (the day shows green if one person has requested it, yellow if two have requested it, and red if three have requested it off). Click on the date box to see who has requested that day off. Also note that it has 2 modes: one to list everyone, and one to list an individual employee.
Sorry to access 97 users, I wrote it in xp (2000 format).
Rob Shuster
Attached File(s)
Attached File  VisionDB.zip ( 215.44K )Number of downloads: 2282
Go to the top of the page
post Mar 3 2018, 06:03 PM

Posts: 71
Joined: 30-October 15
From: Central CT USA

Just a warning for folks who want to use this with newer versions of Access/Windows, it has a reference to a Microsoft Calendar control (mscal.ocx) that you probably don't have, and thus it will not work.
Go to the top of the page
post Mar 3 2018, 06:34 PM

UtterAccess VIP
Posts: 5,768
Joined: 30-June 11

I've upgraded it to accdb format, cleaned out unneeded references, fixed a small coding error that came up when I debugged the code and indented the code. But all in all, it is the same as the original. It works just fine! Just needed a little love which I was more than happy to provide.

Updated 2018-03-03 20:35 -> Updated the download file. It was originally created with Access 2013 and I downgraded it to 2007 to make it compatible for all versions (2007, 2010, 2013, 2016).
Attached File(s)
Attached File  Calendar_Yr_VacReq_V2007.zip ( 132.76K )Number of downloads: 26

Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    19th March 2018 - 01:40 PM