MS Access 2007 SOLVED

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

There seams to be a problem with the 
Calendar.DayView.ScrollToWorkDayBegin function.

AND 

Public Function ScrollToCurrentTime(dTIime As Date)
 Dim Indx As Long
   Indx = m_objCalendarCrt.DayView.GetCellNumber(Format(dTIime, "hh:00"))
   m_objCalendarCrt.DayView.ScrollV Indx
End Function

Nothing will get the control to move to the current work day time in Access 2007. 

Worked perfectly in Access 2002.

~ Robert

Cause & Solution:

Ok, So after a TON of testing and breaking down my app, I have discovered the cause of the problem.

In MS Access 2007, if you have the calendar control on a tab control, and do anything (simply setting focus to a particular tab) in code on the Forms Open Event, the control looses it's ability to be update by code.

In all Previous version of MS Access 2000, XP and 2003 this behavior is not seen.

The solution is to simply perform all modifications to the tab control in the forms Load event after the calendar control is completely initialized.

 ~ Robert

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rgracie Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12 November 2006 Status: Offline Points: 75	Post Options Post Reply Quote rgracie Report Post Thanks(0) Quote Reply Topic: MS Access 2007 SOLVED Posted: 27 July 2008 at 4:10pm
	There seams to be a problem with the Calendar.DayView.ScrollToWorkDayBegin function. AND Public Function ScrollToCurrentTime(dTIime As Date) Dim Indx As Long Indx = m_objCalendarCrt.DayView.GetCellNumber(Format(dTIime, "hh:00")) m_objCalendarCrt.DayView.ScrollV Indx End Function Nothing will get the control to move to the current work day time in Access 2007. Worked perfectly in Access 2002. ~ Robert Cause & Solution: Ok, So after a TON of testing and breaking down my app, I have discovered the cause of the problem. In MS Access 2007, if you have the calendar control on a tab control, and do anything (simply setting focus to a particular tab) in code on the Forms Open Event, the control looses it's ability to be update by code. In all Previous version of MS Access 2000, XP and 2003 this behavior is not seen. The solution is to simply perform all modifications to the tab control in the forms Load event after the calendar control is completely initialized. ~ Robert

rgracie Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12 November 2006 Status: Offline Points: 75	Post Options Post Reply Quote rgracie Report Post Thanks(0) Quote Reply Posted: 28 July 2008 at 5:23pm
	I noticed today that if there is another form open while opening the form that contains the calendar control it works properly. So this is definitely a bug... Robert