MS Access 2007 SOLVED |
Post Reply |
Author | |
rgracie
Groupie Joined: 12 November 2006 Status: Offline Points: 75 |
Post Options
Thanks(0)
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
Groupie Joined: 12 November 2006 Status: Offline Points: 75 |
Post Options
Thanks(0)
|
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
|
|
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 |