Creating a date list

[stupiet]

To anyone who can help,

I'm trying to put a vacation tracking database together.

In it I will have a list of employees.
This is what I want it to do:
When manager opens employee a continuous form opens where in the first column there is a list of dates for the whole year. In the second column they will be able to put in the hours gone for that day. And in the third they can select what kind of vacation they are taking.
Should look something like this:
DATE HOURS TYPE
1/1/06
1/2/06
1/3/06 8.0 Vacation
etc.

A new record in the Vacation Table should be created whenever the manager puts in the hours. I don't want to create 365 records for each employee, as the table will be huge. Is this possible? I have seen it done on the internet but don't know if it's possible in Access.
Hope I was clear with my description.

Thanks for all the help!

Stupiet

 

[fneily]

You might want to consider an "event calendar". I was giving one away, but tek-tips erased my email - against the rules to post your email. But you can look at:

http://www.4guysfromrolla.com/webtech/060599-2.shtml

This is for the web, but you can recode it for just a form.
The user clicks on a date which opens a box to put info in such as vacation, sick leave, etc. I expanded it to keep track of down days (it was for a manufacturing plant).
Also, search the net for event calendars. Some are free, some aren't.

 

[stupiet]

Fneily,

Thanks for your response but the calendar is not what I'm looking for as it takes up more space than just a long list of dates. I need to make it as compact and convenient as possible, and I think that's the only way of accomplishing it.

Thanks again for your help!

 

[fneily]

I'm not sure why you said what you did. The calendar show one month on one form, single page. There are controls to move between months and years. The code that operates the calendar is around 50 lines. The data is kept in a table. I used it for a gypsum plant that had 250 employees and 12 departments.

If what you want is for managers, then have a form where the manager can input an ID. Another form would open with a dropdown showing only his employees. He can then click an employee name, vacation will already be populated in a textbox, another textbox when double clicked would bring up a calendar (access has some activex controls - Calendar, and Datepicker) where the manager just clicks on a data and time. Then click a save button and your done. No typing for the manager thus no errors.

 

[stix4t2]

stupiet,

You could create one table with all the dates and then link it to the table with actual employee, date and reason. Using join you can create the table you want.

You may want to add a month combo to help managers with having to scroll to find a month.

Or if you are really inspired, you could also create a table 1-31 for days and another table with month and number of days, then in the query build the data for the viewer. Any adding or editting would have to be done from a dialog because this kind of query would not be edittable.

Stix 42
Long Live Rock and Roll
Pop is for drinking

 

[MichaelRed]

Perhaps, you could investigate using Outlook's calendar. A shared chaendar for all employees could easily be used for each to post their vacation days, or the manager could just as easily post whatever he desired to a single one, using the employee and whatever other info desires as "appointments". No actual (for you) work involved, althopough (depending on the manager) it might be just as much effort in learnig the features (of Outlook) and then getting the manager to use it intelligently.

And, oh by the way, since Outlook is a Ms. Product, a small bit of digging and you can get the info to trvel back and forth, so any 'fancy' reporting could be done in Ms. Access,.



MichaelRed