Calendar - MS Access 2007 SOLVED

MS Access 2007 SOLVED

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=11604
Printed Date: 19 July 2025 at 9:00am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: MS Access 2007 SOLVED

Posted By: rgracie
Subject: MS Access 2007 SOLVED
Date 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

Replies:

Posted By: rgracie
Date 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