ActiveX Version: 13.2

OS: Vista Pro SP2

Development: MS Access 2003 & SQL Server 2005 Express

 

had it all working good. after a BSOD crash - cant load recurrent events no matter what.

 

Implementd all the customised events for using SQL server DB. all works fine except when I try to load the events back from the tables. the data is written to the tables (including the recurring pattern).

 

I put a breakpoint in the code for the event: DoReadRPattern
here is it:

Private Sub MainCDR_DoReadRPattern(ByVal PatternID As Long, pPattern As Object)
  Dim rs As New ADODB.Recordset

  '****BREAK POINT HERE

  rs.Open "SELECT * FROM CdrRecurrencePattern WHERE RecurrencePatternID = " & PatternID, _
      CurrentProject.Connection, adOpenStatic, adLockReadOnly
  Set pPattern = getRPatternFromRS(Me.MainCDR, rs)
  rs.Close
  Set rs = Nothing
End Sub

When I call Populate - it is not called(althogh I have a recurring pattern).
Also, I read the help for the calendar object and found that this event is calld when I call DataProvider.GetRecurrencePattern:

Set pRPattern = Cdr.DataProvider.GetRecurrencePattern(PatternID)

When I call this directly - it should call the custom event procedure. BUT no matter where in the code, the result for this is always NOTHING.

Any ideas ?