UtterAccess.com
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    
 
   
RJS
post Sep 3 2003, 10:31 AM
Post#1



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: 2450
 
Go to the top of the page
 
ws1o
post Mar 3 2018, 06:03 PM
Post#2



Posts: 104
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
 
DanielPineault
post Mar 3 2018, 06:34 PM
Post#3


UtterAccess VIP
Posts: 7,000
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: 307
 
Go to the top of the page
 
thomassoler
post Feb 8 2019, 11:17 AM
Post#4



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
 
DanielPineault
post Feb 8 2019, 11:42 AM
Post#5


UtterAccess VIP
Posts: 7,000
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: 32
 

--------------------
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    9th December 2019 - 08:05 AM