Codejock Developer Community : MS Access 2007 SOLVED http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 29 May 2026 22:35:59 +0000 Mon, 28 Jul 2008 17:23:42 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=11604 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[MS Access 2007 SOLVED : I noticed today that if there...]]> http://forum.codejock.com/forum_posts.asp?TID=11604&PID=39010&title=ms-access-2007-solved#39010 Author: rgracie
Subject: 11604
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
]]> Mon, 28 Jul 2008 17:23:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=11604&PID=39010&title=ms-access-2007-solved#39010 <![CDATA[MS Access 2007 SOLVED : There seams to be a problem...]]> http://forum.codejock.com/forum_posts.asp?TID=11604&PID=38948&title=ms-access-2007-solved#38948 Author: rgracie
Subject: 11604
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
 
]]> Sun, 27 Jul 2008 16:10:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=11604&PID=38948&title=ms-access-2007-solved#38948