Reflex_ht
Registered User.
- Local time
- Yesterday, 16:49
- Joined
- Sep 11, 2012
- Messages
- 64
Hy,
We are working on a DB for our Personal. A part of the DB is the Vacation DB. We managed to make the Vacation DB in Access and also have made a Vacation Calender in Access.
Now we are becoming Outlook with a Exchange Server
giving us greate oppertunities.
I planed and I know that it is possible to use the a Public Outlook Calender as an Vacation DB. The main thing baout it:
-Only the Personal that is working with the Personal Vacations as "writh" permition to the Public Calender
-In access the calender can be selected with a funktion
-The user enters just the start and end date of the Vacation and the app adds appointments to the calender with a loop so that every day is added seperately
REASON:
1. Sometimes workers cancel only one vacation day or more. If we add appointments as just one over more days it would be a mess to adjust all that changes.
2. The durration of the appointment is the working hours of the worker (because there are vacations that are just for a part of the day). The durration is in that case used to determinat if the vacation in that day is a full or just a part of a day. The durration is mostly 8h for a day. For some workers it is 4 or 6h.
-The app is not just used to add appointments to the Calender as vacation entrys. It is also used to analyze te vacation day for our employes. Because of that we have to enter this kind of data in to the appointmen:
Employ name (Location)
Typ (Vacation or if he is Ill) (Subject)
Start, Enddate and durration Time (the appointment time options)
Standard working hours in one day for that employer (appointment resources -this is invisible for the users to see in Outlook because it is a parrameter that should ot be changed by the user)
Notification if there are other Information to add (body)
All that I have already done.
Now I´m working on the vacation days of our country like Christmass. If someone has vacation at that day it won't count. I´t should be possible that the app rekognises if in the date it wants to add a appointmen is already a vacation day like christmass so that it just skips that day.
Also the analysing had to be done but i alredy made some parts of it.
Enough of the explanation. Now the cuestions:
1. Does someone has expiriance with something like this?
2. Is it safe to make the vacation DB in Outlook. Can we lose data or something similar?
3. Does it make sense?
I see lots of PROs for this solution.
-all employes are sending vacation/holiday reguestes to the one user managing this all - no conflicts!
-they all see a actual vacation calender with only those vacations that are aproved
-they can´t add for them alone vacations - it must go over the one user
-the one user has to add a vacation for a employer just one time
(with our access DB he adds it in access and in a public calender and by changes he has to apply the changes in both)
-changes in outlook will be automatically applied in access analyse
-it is mutch faster as in access! (I made a calender in access but it is using so mutch performance that it is not easy to work with it
)
We are working on a DB for our Personal. A part of the DB is the Vacation DB. We managed to make the Vacation DB in Access and also have made a Vacation Calender in Access.
Now we are becoming Outlook with a Exchange Server
giving us greate oppertunities.I planed and I know that it is possible to use the a Public Outlook Calender as an Vacation DB. The main thing baout it:
-Only the Personal that is working with the Personal Vacations as "writh" permition to the Public Calender
-In access the calender can be selected with a funktion
-The user enters just the start and end date of the Vacation and the app adds appointments to the calender with a loop so that every day is added seperately
REASON:
1. Sometimes workers cancel only one vacation day or more. If we add appointments as just one over more days it would be a mess to adjust all that changes.
2. The durration of the appointment is the working hours of the worker (because there are vacations that are just for a part of the day). The durration is in that case used to determinat if the vacation in that day is a full or just a part of a day. The durration is mostly 8h for a day. For some workers it is 4 or 6h.
-The app is not just used to add appointments to the Calender as vacation entrys. It is also used to analyze te vacation day for our employes. Because of that we have to enter this kind of data in to the appointmen:
Employ name (Location)
Typ (Vacation or if he is Ill) (Subject)
Start, Enddate and durration Time (the appointment time options)
Standard working hours in one day for that employer (appointment resources -this is invisible for the users to see in Outlook because it is a parrameter that should ot be changed by the user)
Notification if there are other Information to add (body)
All that I have already done.
Now I´m working on the vacation days of our country like Christmass. If someone has vacation at that day it won't count. I´t should be possible that the app rekognises if in the date it wants to add a appointmen is already a vacation day like christmass so that it just skips that day.
Also the analysing had to be done but i alredy made some parts of it.
Enough of the explanation. Now the cuestions:
1. Does someone has expiriance with something like this?
2. Is it safe to make the vacation DB in Outlook. Can we lose data or something similar?
3. Does it make sense?
I see lots of PROs for this solution.
-all employes are sending vacation/holiday reguestes to the one user managing this all - no conflicts!
-they all see a actual vacation calender with only those vacations that are aproved
-they can´t add for them alone vacations - it must go over the one user
-the one user has to add a vacation for a employer just one time
(with our access DB he adds it in access and in a public calender and by changes he has to apply the changes in both)
-changes in outlook will be automatically applied in access analyse
-it is mutch faster as in access! (I made a calender in access but it is using so mutch performance that it is not easy to work with it
)