Codejock Developer Community : MS Access and recurrent events http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 30 May 2026 02:14:29 +0000 Fri, 18 Jan 2008 10:37:36 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=5578 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[MS Access and recurrent events : Hi Erwin,I have a similar environment...]]> http://forum.codejock.com/forum_posts.asp?TID=5578&PID=30272&title=ms-access-and-recurrent-events#30272 Author: dangier
Subject: 5578
Posted: 18 January 2008 at 10:37am

Hi Erwin,
I have a similar environment -- SQL Server backend and MS Access frontend. Also, most of the events are Master events with an associated recurrence. At this time, only the exceptions show up on the calendar--not the master events (recurrencestate = 1). Would you mind sharing what you found as a solution?
]]> Fri, 18 Jan 2008 10:37:36 +0000 http://forum.codejock.com/forum_posts.asp?TID=5578&PID=30272&title=ms-access-and-recurrent-events#30272 <![CDATA[MS Access and recurrent events : I&#039;m using V10.3.1 of the...]]> http://forum.codejock.com/forum_posts.asp?TID=5578&PID=17541&title=ms-access-and-recurrent-events#17541 Author: Erwin
Subject: 5578
Posted: 22 November 2006 at 4:32am

I'm using V10.3.1 of the ActiveX CalendarControl from within MS Access but based on a SQL Server 2000 database. In other words, the MS Access application is just a front-end for the SQL DB. I have managed to get the Calendar working on the SQL Server backend via a custom dataprovider based on the VB sample. Everything works fine as far as non-recurrent events are concerned. Recurrent events are also stored correctly in the database but there seems to be a problem when retrieving these events.
 
Although I use the custom properties method in my CreateEventFromRS routine, the master event does not appear to be created correctly. I have debugged the entire data provider and everything seems to be working OK (DoReadPattern gets called to read the pattern and the exceptions for the master event, etc.). Also, the dataprovider is called to create all the occurences of the given recurrence pattern. However, when, later on I try to access the recurence pattern for any given occurence (e.g. to find the master event) I find that it is not there.
I get the feeling that the event and the recurrence pattern is read correctly by the data provider but they are somehow not tied together properly by the control itself (i.e. by the hidde/common part of the DataProvider).
 
Does anybody have any ideas?
]]> Wed, 22 Nov 2006 04:32:07 +0000 http://forum.codejock.com/forum_posts.asp?TID=5578&PID=17541&title=ms-access-and-recurrent-events#17541