Codejock Developer Community : DatePicker ocx and Access http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 15 Apr 2026 16:11:00 +0000 Wed, 16 Jul 2008 11:27:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=11425 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[DatePicker ocx and Access : dr.iak wrote: Hello, I...]]> http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38465&title=datepicker-ocx-and-access#38465 Author: StephenMurphy
Subject: 11425
Posted: 16 July 2008 at 11:27am

Originally posted by dr.iak dr.iak wrote:


Hello,

I also use the datepicker and the calendar control in an Access 2003 project and the AttachToCalendar method works perfectly.

Greetings

Bernd


Isn't that odd? I have tried it on two machines here with Access 2000/2003 and 2007, and in all three environments, the DatePicker control is missing many methods that Intellisense does not pick up. Perhaps because there are two interfaces in the ocx and Access on my machines is ignoring the second. I unregistered and re-registered the control several times but that didn't help.

My solution was to make the call as follows:

Call DatePicker1.AttachToCalendar(Me.CalendarControl1.Object)
 
That did the trick and connected the two.
]]> Wed, 16 Jul 2008 11:27:16 +0000 http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38465&title=datepicker-ocx-and-access#38465 <![CDATA[DatePicker ocx and Access : Hello, I also use the datepicker...]]> http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38452&title=datepicker-ocx-and-access#38452 Author: dr.iak
Subject: 11425
Posted: 16 July 2008 at 7:02am


Hello,

I also use the datepicker and the calendar control in an Access 2003 project and the AttachToCalendar method works perfectly.

Greetings

Bernd]]> Wed, 16 Jul 2008 07:02:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38452&title=datepicker-ocx-and-access#38452 <![CDATA[DatePicker ocx and Access : Just as a followup, I am still...]]> http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38332&title=datepicker-ocx-and-access#38332 Author: StephenMurphy
Subject: 11425
Posted: 14 July 2008 at 11:25am

Just as a followup, I am still unable to get the AttachToCalendar method of the DatePicker control to become available in Access 2003. The datepicker and calendar controls do seem to function properly in the form otherwise.

Is there a way to transfer info from the datepicker to the calendar manually in a SelectionChanged event? The following seems to work:

Private Sub DatePicker1_SelectionChanged()
Dim dpSel As DatePickerSelection

    Set dpSel = DatePicker1.Selection
   
End Sub

Is there a way to tell the calendar to use that selection in its current view?

Any help appreciated.
]]> Mon, 14 Jul 2008 11:25:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38332&title=datepicker-ocx-and-access#38332 <![CDATA[DatePicker ocx and Access : I am trying to use the Calendar...]]> http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38308&title=datepicker-ocx-and-access#38308 Author: StephenMurphy
Subject: 11425
Posted: 13 July 2008 at 10:32pm

I am trying to use the Calendar demo ocx in Access 2003. The control registers ok and I am able to insert an instance of both the Calendar and the Date Picker onto the form and they both appear properly at runtime. However, the correct methods for the DatePicker seem to be missing, and I am only allowed to pick from general ole control properties. I can't access any of the DatePicker specific methods or properties such as AttachToCalendar. I just get the error "Class does not support Automation or does not support expected interface." 

Is there any way to rectify this? I have registered and unregistered the control several times, but it doesn't seem to help.

It works fine in VB6, but not Access. Any help appreciated.
]]> Sun, 13 Jul 2008 22:32:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=11425&PID=38308&title=datepicker-ocx-and-access#38308