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: 2456
Go to the top of the page
post Mar 3 2018, 06:03 PM

Posts: 116
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: 7,066
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: 319
Go to the top of the page
post Feb 8 2019, 11:17 AM

Posts: 1
Joined: 26-January 19

Hi Daniel, Cool upgrade but the colors are inconsistent with the dates.
Go to the top of the page
post Feb 8 2019, 11:42 AM

UtterAccess VIP
Posts: 7,066
Joined: 30-June 11

I just tested and everything seemed fine to me. That said, I didn't create the code behind the forms... I just tried to perform a minor upgrade to help out.

Attached File(s)
Attached File  2_8_2019_11_40_38_AM.jpg ( 225.27K )Number of downloads: 37

Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://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    25th January 2020 - 07:28 AM