Vacation Calendar


I was wondering if there was a way to make a calendar in Access 2003? I work in a group of 60 employees and we track their vacation, and personal days in a web-based application. The web-based application is going away, as it it no longer supported. Could I use Access to create a calendar for the 60 employees and have it require a user name and password for them to log into the database to look at what vacation they have?

Would Visual Basic or C++ be a better program for this?



View Replies


Employee Vacation Request Calendar

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

View Replies View Related

Vacation Scheduler

There are some ideas floating around these forums on "booking" databases and whatnot, but I have a bit of a different twist with what I am trying to accomplish.

I am trying to develop at database that will allow users to log in and schedule their vacations. I have 2 tables at the moment tblEmployees and tblVacations. In the tblEmployees table you have:

EmployeeID (autonumber)
EmployeeName (text)
HireDate (date)
weekseligible (text)

the weekseligible field will be entered manually and be between 3 to 6 weeks of total possible vacation weeks.

The tblVacations has the following fields:

ID (autonumber)
weekofyear (date field with week starting sunday for all 52 weeks)

Only 4 people can take vacation any one week of the year. The vacation fields will be combo boxes where an employee can select their name from a query based on the employees table.

What i need to happen is to prevent someone from scheduling more weeks than their weeks eligible - I have no idea how to do this. My guess is there should be someway to do this using queries and somesort of a count function, but I am having a hard time getting started.

any help is greatly appreciated.

Thank You!

View Replies View Related

Vacation Tracker

Since posting the screen shots for the vaction tracker in the User Interface Design forum, I've had a couple of direct requests and noticed some other posts about vacation tracking. So, I am making the entire app available. There is data in it, but the names have been scrambled with a character randomizer (see the myRandChr procedure in the basModule module).

The attachment and the clickable link above (the image) are a zipped Access 97 version. I've tested it in A2K and AXP. No problems conrverting or simply running. Neither are there any ActiveX controls or special reference libraries. The only reference libraries used are only those that Access 97 defaults to. (Just to note the use of DAO 3.51) The attachment would most likely not ever change, so the clickable image link is the one most likely to have updates, when and if they occur.

Vacation and personal times are calculated, based on the employee's anniversary date. I did not provide a table to store the values of how many hours an employee is annually entitled to per years of service. That is currently controled by use, instead, of the avHours field, (for vacation hrs), and the apHours field, (for personal hrs), in the employee's table. In the detailed employee form, (frmEmpSngl), the entitled hours based on years of service is hard coded to auto populate the avHours and apHours fields in that form when an employee's anniversary date has been entered. Both can be edited.

There is a twist however, I have also provided a way to manually enter "banked" vacation hours (hours left over from the previous year). So, when banked hours are displayed, the manually entered values are checked for first, and if not found, then the calculator procedure is used. But not in the detailed employee form.

Just remember that each Employee MUST have an anniversary date or the calculations will not work.

The tricky part was getting all the formulas to work well within query behind the annual forms and reports. But that got easier when I decided to make the annual forms read-only.

You modify an employee's vacation or personal hours by single-clicking on the cell that matches an employee and month in a given year, whereupon a calendar form pops up and allows you to edit hours used. Double-clicking on an employee's name in the annual view will open that employee's detailed form.

The year gizmo is constrained to never go beyond the current year nor less that the earliest recorded anniversary year.

In the pop-up employee calendar form, you can not go below the employee's month and year of hire. Also in the pop-up employee calendar, you enter vacation time beyond the current date for planning purposes. And so far, I've not implemented a methodology for viewing future, planned vacation days, except in the employee's calendar pop-up form.

It's not locked up so all the code is available for your personal, mangulatory delight. There is little commenting in the code.
(I employ Klingon commenting techniques)

You are free to do what you will with it EXCEPT sell it as is. If you do, you must send any monies acquired to the folks at UA. They've earned it.

View Replies View Related

Employee Vacation Tracking

My computer crashed and I lost my employee vacation tracking database.

Does anyone have an Excel spreadsheet or other tracking method they could share please? I really don't have time to build a new database.

Thank you for your help.

View Replies View Related

Vacation Database - Version: 2002 (10.0) XP

Current vacation database works well. But, with new contract,vacation database will now have to use two vacation time lines. With new contract vacation time will be less. For example the employees who have worked 10-15 years now, have 4 weeks vacation. Employees who will complete 10 years service tomorrow will have 3 weeks and 2 days vacation. It will be 5 years until new vacation time will be (almost) used for everyone. The top vacation time will be 6 weeks for 25+ years , new contract . The old contract was 7 weeks for 25+ and the employees who have 7 weeks will continue to receive them until they retire. Any suggestions on how to handle two different vacation lengths in one database would be greatly appreciated. thanks

View Replies View Related

Vacation/ Out-of-Office Reports - Version: 2000 (9.0)

Hi everybody ,

I hope this posting finds you all well.

I have this Access 2000 DB (“test_Vacation”) to modify, which I am attaching, and unfortunately was not initially built by me. What this is, a customized Vacation/ Out-of-Office Database. And, basically I need to create Reports for them. Right now, there are couple of Reports; one of which is simply a Crosstab Query, which is still not showing the Data functionally. If someone can jump in and help me out, that’d be great - you will find the Report (“Help”) helpful, for it provides more detailed/ specific Improvements that need to be made on Reports. I provided some general suggestions for you here:

1.You can create a Form: Each employee by Month block – total for EX: May; better yet by Week.

2.By WEEK, I’d like to see: who’s Out/ who’s In (like the Matrix, but need to fix the dates there to Count - “run by day”)

3.The reports there right now are not functioning properly

4.For Matrix Report, you may use a Tbl_CLNDR w/ all working/ Business days (so not to keep recreating them). Right now, where the dates are correlated, it shows Names and all days @ Top, whether OR not the Employees are there OR not - but I need to get a Range, so it would show in month for EX:

a.Only April days, because it would take from the Tbl_CLNDR, and where they correlate with somebody’s date, it would have 1 or 0. After this Form is clean, it would chose a Report, which needs to be able to run a Matrix and just don’t show days (Null) that are not being occupied in the calendar at all.
i.Right now the Matrix Form is done by the number of the month / Year/ to show that timeframe

5.You may think of other Reports to include, to be able to know ahead who’s going Out that “Week” (currently an incorrect name, for it is more of a 7 days in a Month) – please be my Guest, fire away with anything that you think might help my Calendar analysis.

To sum it up, for Weekly Report: you can count the number of the week, and then group by Week, as well as separate reports by Month/ Year, with total for Days please. If this info doesn’t help, the Report “Help” should brief you with little more insight. Hopefully you get the idea, and if someone could please simply tweak and make the existing or new Reports work.

Much of luck and in advance,

View Replies View Related

Access - Calendar Control - Code To 'popup' Calendar - Version: 2003 (11.0)

I'm trying to use a calendar in Access 2003 to enter data in data fields.
I found a site that showed how to write the code so it will popup when you click on the date field and then disappear when you select the date from the calendar.
I got it working but I want to be able to access that same calendar for other date fields on the form.
So I used a variable call 'originator' to pass the originators name to the variable.
Only thing it doesn't work. I get a type mismatch error and I don't know why. It's exactly the same as the example I found(obviously with my names substituted in).

Please help. (dob is the field I want the date to go into and Calendar6 is the name of the calendar I'm using.) Here's my code:

Option Compare Database
Option Explicit
Dim originator As ComboBox

Private Sub dob_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

Set originator = dob
Calendar6.Visible = True

If Not IsNull(originator) Then
Calendar6.Value = originator.Value
Calendar6.Value = Date
End If

End Sub

Private Sub Calendar6_Click()
originator.Value = Calendar6.Value
Calendar6.Visible = False
Set originator = Nothing

End Sub

View Replies View Related

Calendar Control, Creating A Real Calendar - Version: 2000 (9.0)

Anyone ever created a calendar with the calendar control in Access?

Me.CalendarName.Value gives the date that the user is clicking on and is normally used in putting dates into a "meeting" schedule or whatever, opening the Calendar so that a user can click on it.

I'd like to create a real calendar. If I can't figure out how to get text into the Calendar boxes, perhaps I'll simply circle each date with an appointment on it and put all the appointments up into a list box right next to it or something. Anyway, before i reinvent the wheel, has anyone done something like this before?

View Replies View Related

Delete Calendar Items In Outlook Calendar Using Vba - Version: 2000 (9.0)

I am trying to delete outlook calendar items using vba, but it is not working.

The code is pasted below. It looks for calendar items with a category of "Holistic" and then should delete them.

On Error GoTo Err_command264_Click

Dim olApp As Outlook.Application
Dim olNS As Outlook.NameSpace
Dim olFolder As Outlook.MAPIFolder
Dim olItems As Outlook.Items
Dim olAppt As Outlook.AppointmentItem
Dim db As dao.Database
Dim rs As dao.Recordset
Dim w_start As String
Dim w_end As String

Set olApp = New Outlook.Application
Set olNS = olApp.GetNamespace("MAPI")
Set olFolder = olNS.GetDefaultFolder(olFolderCalendar)
Set olItems = olFolder.Items

For Each olAppt In olFolder.Items

If olAppt.Categories = "Holistic" Then
End If

Next olAppt

MsgBox "Successfully deleted appointments", , g_system_name


Set olApp = Nothing
Set olmapi = Nothing
Set olcontacts = Nothing

Exit Sub

MsgBox err.Description & rs!Expr1
Resume Exit_command264_Click

End Sub

View Replies View Related

The Dreaded "Vacation Accrual" Queston.

Please bear with me.

I'm fairly new to access, and have learned much in the past three weeks I've been "learning" how to use it.

I was simply sick of the process that was going on at my place of business where I'm a Manager (I've been there for about 3 months). We keep about 10 Excel forms for the different pieces of information (production numbers and such) we keep for each individual in the department. There are 115 people, 3 shifts working 24 hours a day. Each morning I would go in and open each excel file to analyze what happened the day before.

We're also tracking an individual's days off, tardiness, quality... you name it.

I finally decided it was time for a database... I had worked with them in the past, but I had never actually "built" one. I've actually knocked out a significant portion of what needs to be done, and I'm proud of my product thus far... except for one thing:

Vacation accrual is "kicking my posterior"!

I've searched these forums (finding some answers, most of which I don't understand), but I almost need to be handed the answers. My other struggles I've overcome with the help of these very forums and Google.

I'll lay out our policy and what I need and hopefully someone can help me. As I learn access (and I will!), maybe one day I could come back here and help someone else that may be in need.

Our policy is as follows:

90 Days to be eligible for accrual.

1-3 years of service - 6.67 Hours a Month (10 Day a year or 80 Work Hours... all the same, and whichever makes things easier)
4-7 years of service 10 hours a month (same deal as above as 15 days or 120 work hours)
+8 years -13.33 hours a month (blah blah)

The hours do NOT carry over, they are all use it or lose it. I can make manual entries when necessary, so it doesn't have to be all "automatic".

Like I said, the searching I've done has come up with some things, but not in the language I yet understand. I do know "modules" and some expressions, but the more that could be "spelled out" the better.

I've got your (what I consider) normal Employee fields, and would like to use something like "DateStarted" as a beginning point, but I'm open to anything.

Thank you VERY much in advance for any help that can be given. This has stalled my project almost a week trying to figure out a solution!

View Replies View Related

Calendar Links To Outlook Calendar

I have a date field that utilizes a calendar object to fill in the field. I would like for this date field to also link with Outlook and put this date on the users MS Outlook calendar or task list. Is this possible?

View Replies View Related



I've putted on calendar on an database but by example when I press first of June how can I make it recognise which week day is it?


View Replies View Related


Hi All!
I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....

Please advice,

View Replies View Related

Do More With Calendar Example

hi there, i have been using the calendar from the following site:

i want to add more features to this calendar. at the moment im just researching the possibilities..

i have a table with dates, there are dates when certain documents expire. i just want the above calendar to put a little mark on those dates, to remind me of when the documents expire. when i click on that date, i want it to show me which doc is expiring..

has anyone done anything like this before using the calendar apps?


View Replies View Related


Using an activeX calendar. I have 2 questions.

1) Is it possible to have certain dates always highlighted in the calendar so the user can clearly see these dates. What I'm looking for specifically is to have each second thursday always highlighted with another color.

2) Using a seperate form and calendar than the one above, how would I go about using a calendar to search for old records (apply a query to it maybe, but how would I do that?) so that when I click on a date, the records for that specific date are opened.

I really appreciate any help that anyone can offer with either question. If you leave an answer in code, can you please clearly define what you named each item that I may need to replace, i.e. Calendar, Date, etc., because I'm not incredibly familar with using code.

Thanks in advance for the help, I will be able to respond quickly if you have any questions or if I didn't explain anything clearly.

View Replies View Related


Hi All!
I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....

Please advice,

View Replies View Related


I am trying to use a calendar to fill the date box on a simple form, I have used the examples from various threads on here but I cannot get the calendar to pop up.

The error message I get is

Run Time Error 2110
Microsoft Access cant move the focus to the control activeXCt161

Any thoughts on how I can fix the problem?

View Replies View Related

Calendar 2k

can someone help me find the calendar2k file. I downloaded it a little while ago but cannot find it now. It has a frmcalendar, a module, and then you copy the 2 little calendar buttons on your form for it to work. You then set the OnClick function on the control box you want it to enter the date from the calendar dialogue box.



View Replies View Related

Pop Up Calendar - How?


I have seen pop up calendars in use in other databases and wondered if it was possible to put one into my current DB. (The standard little Microsoft style one).

Rather than using a direct entry date field in my form how do I go about adding in a pop up calendar. Can this be done easily?


View Replies View Related

Calendar Help

i cant hide the calendar when u open the form and i cant click a date without an error appearing help please

View Replies View Related

Calendar Help

Hi all.

I'm trying tosetup a pop up calendar in my Access Database for users to select start and finish dates of activities. I have a calendar from here:

Here is my problem, When I run the database "Calender2000" it works fine. The calendar is displayed, but when I import the database (using get external data), and try running the calander, I get the following error:

"The expression you entered has a function name that Microsoft Office Access can't find.@."

I am fairly new to Access, and currently using Access 2007. Any help appreciated (I can follow instructions in Access 2003 format).


View Replies View Related


I am getting myself into knots trying to solve this can anyone help:

I need a calender so that the user can book and check availability of courses for each date. ie course 1 has 5 places on this date, once one is booked then there should be 4 places left.

Does anyone know if there is a graphical form available which I can use for this function and serve the dual purpose of data entry?

View Replies View Related


Hi, I have find this calendar, wich is great for me as my ACCESS program is in italian and all calendars I have find gives me back date and month values in italian, this one I can set it either italian or english!!!
What I need is to make it visible on double clicking on the date on a form and once opened selecting the dae on the calendar it returns the value onto my date field on the form.

View Replies View Related


I would like to create a text box that when it has focus a calendar pops up, allows the user to select a date and then disappears after a date is selected, leaving the date (mm/dd/yyyy) in the textbox. Anyone know where code may be available -- I am willing to pay for it? Thanks ...

View Replies View Related

Web Calendar


I've been looking for a way to create a Web Calendar, so I was very excited to see your sample . However, the HTML file doesn't seem to display all events.

I imported data from my database and appended the data to the appropriate fields in your table so I didn't have to touch any code.

When I run the report for Jan 2006 I get 12 Events displayed in the HTML report -this is correct (I have 12 events for the month.)

However, I have 10 events for February and when I run the report I only get 2 events displayed.

In April I have 5 events. The report only displays the first 2 -and the first event, which is 4/5/06, actually displays in the square above the correct date box on the form (the box it displays in is before the beginning of the calculated month.)

I can not figure out what is wrong. I can easily email you the db to which I imported the data.

Thanks for your efforts.


<a href=""></a>

Edited by: argeedblu on Thu Dec 29 17:17:45 EST 2005.

View Replies View Related

Orders Calendar

i am trying to find a code that will present me some orders calendar of rooms.
i a trying to build some calendar that will show me the order date and the end date of the roon, rent by te customer, somehow that i will see that all the dates between these two date are occupied, like an outlook calendar.

View Replies View Related

Calendar Property

Please pardon my ignorance, but how do I set up a ActiveX calendar in Access? The help files are missing from the version of Access 2000 I am using, and I really don't know what I am doing. I would be grateful for any help with this.


View Replies View Related

Calendar Format On DAP?


I've created a database to keep track of schedules, and have created a report that displays like a calendar.

Similar to Pat's example here

What I would like to do now, is create a DAP that will display in a similar format. But because the report uses subreports, it doesn't just tranfer over.

Does anyone have any ideas on how to create a simlar calendar format, within a DAP?

We want to use this on our intranet, so everyone can see each others schedules, and this is the only thing left I have to do. I just can't seem to get anything to work.


View Replies View Related

Calendar Pop-Up Version


I just created a calendar pop-up for data entry in Access Version 2002 and it does not work with Access 2003. Any help from anybody would be appreciated!

View Replies View Related


Does anybody know if MSCAL.Calendar.7 can be set so that Sunday shows as the first day of the week instead of Monday.My company uses a timesheet with a week begginning on Sunday.

View Replies View Related

Reference Calendar

Is there a way to insert a calendar on a form from which a user can select a Month year and day similar to using the calendar on Outlook or Lotus Notes to set up or view appointments or meetings?

View Replies View Related

ActiveX Calendar

I use the Calendar ActiveX to select a date.
The calendar have a dropdownlistto post the selectede date?
I the calendar to dissapear after the date is selected. The selected date should remain in the drop down list.
I think that the control have a dropdownlist to show the selection, but i didn't found it.

View Replies View Related

Copyrights 2005-15, All rights reserved