Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Vacation Calendar


Hi,

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?

Thanks,

Chris


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
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)
vacation1
vacation2
vacation3
vacation4


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
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
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
Calendar
Hy!

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?

Thanks

View Replies !   View Related
Calendar
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,
B

View Replies !   View Related
Do More With Calendar Example
hi there, i have been using the calendar from the following site:

http://allenbrowne.com/ser-51.html

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?

thanks

View Replies !   View Related
Calendar
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
Calendar
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,
B

View Replies !   View Related
Calendar
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.

Thanks,

Rainman

View Replies !   View Related
Pop Up Calendar - How?
Hello,

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?

Thanks

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: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=413286

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).

sugar05

View Replies !   View Related
Calendar
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
Calendar
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.
Thanks
Marco

View Replies !   View Related
Calendar
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
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.

Thanks.

View Replies !   View Related
Calendar Format On DAP?
Hi,

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
http://www.google.com/url?sa=D&q=http://www.access-programmers.co.uk/forums/showpost.php%3Fp%3D288791%26postcount%3D17

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.

thanks
Chris.

View Replies !   View Related
Calendar Pop-Up Version
Help!

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
MSCAL.Calendar.7
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.
Thanks

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.
Thanks,
Richard

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved