Way to find the conflict events |
Post Reply |
Author | |
karthiksp
Groupie Joined: 09 May 2007 Location: United States Status: Offline Points: 30 |
Post Options
Thanks(0)
Posted: 10 April 2008 at 9:04am |
Hi All,
I have a quick question to check with regarding calendar control. I am setting up an event for a future date let's say
July 1st from 9.00 AM - 10.00 AM
Before that I have another recurring event occurs every 6 month from 9.00 AM - 10.00 AM from 1/1/2007 - 12/31/2008. This recurring event conflicts with the above event.
So when user configure the one time event for "July 1st from 9.00 AM - 10.00 AM" how will I identify the recurring event conflicts with this event in order to notify to user.
Any help is greatly appreicated.
Thanks
Karthik
|
|
mybsys
Groupie Joined: 06 April 2006 Status: Offline Points: 10 |
Post Options
Thanks(0)
|
Hello, Were you able to figure out a solution for this? I've been struggling with recurring appointment conflicts... grrr!
Thanks,
Mike
|
|
Access2007
Groupie Joined: 21 April 2009 Location: United States Status: Offline Points: 13 |
Post Options
Thanks(0)
|
What I did in order to solve this problem was to bypass the built-in recurring event form and create my own that did 4 things:
1. Searched the database for conflicting appointments 2. Created actual multiple appointments in the event table that weren't conflicting with existing appointments 3. If there were conflicts, move the appointment for that date to the next available open time. 4. Show the user the proposed appointments before finalizing. I don't know if there is a simpler way around this, but it worked for me as for my application I needed each of the recurring appointments to show up in the event table for use in other parts of the application. |
|
Windows 7 Pro 64
Access 2007 Calendar 15.3.1 |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |