reoccurent events wont load

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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 ?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
daniel58 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 22 November 2009 Location: Israel Status: Offline Points: 5	Post Options Post Reply Quote daniel58 Report Post Thanks(0) Quote Reply Topic: reoccurent events wont load Posted: 22 November 2009 at 12:10pm
	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 ?