S
Sangeeta
Hello
Could someone help me with this.
I have created a new calender that schedules shifts according to a
chosen date range. With the help of Sue Mosher's label colouring code.
I successfully colourd labels too according to the shift. No complaint
till there.
I would like know if there is some way i can track the appointments
that overlap. I actually use two categories of shifts. 9 to 1:30 and 1
to 5:30 (they are forced to overlap ) . All my schedules are devided in
to two categories "Shift Primary" and "Shift Backup".
If i set my items collection to
Set SupportItems = AllItems.Restrict("[Categories] = 'Shift Primary' OR
[Categories] ='Shift Backup'")
I can get a resultset set of all what i have entered.
What i would like to do is, find out if these categories are overlaping
with already existing (any) appointments on the calender.
-for example "Shift primary" overlaps with "training team meeeting"
-omit the overlap between the two shifts for half an hour. ( I am
forcing it to avoid lunch break absence problem)
If they do overlap i would like to display a message.
Is there some way i can do this. The program is in VBA.
Any help appreciated
Thank you,
Sangeeta Michael
Could someone help me with this.
I have created a new calender that schedules shifts according to a
chosen date range. With the help of Sue Mosher's label colouring code.
I successfully colourd labels too according to the shift. No complaint
till there.
I would like know if there is some way i can track the appointments
that overlap. I actually use two categories of shifts. 9 to 1:30 and 1
to 5:30 (they are forced to overlap ) . All my schedules are devided in
to two categories "Shift Primary" and "Shift Backup".
If i set my items collection to
Set SupportItems = AllItems.Restrict("[Categories] = 'Shift Primary' OR
[Categories] ='Shift Backup'")
I can get a resultset set of all what i have entered.
What i would like to do is, find out if these categories are overlaping
with already existing (any) appointments on the calender.
-for example "Shift primary" overlaps with "training team meeeting"
-omit the overlap between the two shifts for half an hour. ( I am
forcing it to avoid lunch break absence problem)
If they do overlap i would like to display a message.
Is there some way i can do this. The program is in VBA.
Any help appreciated
Thank you,
Sangeeta Michael