Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Calendar Control

I created some forms that use the MsOffice Calendar Control. I understand
that this control is installed with MsAccess.

I am using these sheets on another computer that has MsOffice installed, but
not MsAccess. I copied the MSCAL.OCX to the office directory on the new
machine and this resolved the "reference" errors. However, when I try to use
the control, I get a compile error "Method or data member not found" on the
statement "Calendar.calDate.Value = Cstr(Int(Now()))"

Is there something else that I need to do to deploy this control to a
computer that has MsOffice installed, but not MsAccess.

inTHANKSadvance
....jim
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Calendar Control

You might want to take a look at Ron de Bruin's site for some tips/code/free
calendar control:
http://www.rondebruin.nl/calendar.htm

Jim Zeeb wrote:

I created some forms that use the MsOffice Calendar Control. I understand
that this control is installed with MsAccess.

I am using these sheets on another computer that has MsOffice installed, but
not MsAccess. I copied the MSCAL.OCX to the office directory on the new
machine and this resolved the "reference" errors. However, when I try to use
the control, I get a compile error "Method or data member not found" on the
statement "Calendar.calDate.Value = Cstr(Int(Now()))"

Is there something else that I need to do to deploy this control to a
computer that has MsOffice installed, but not MsAccess.

inTHANKSadvance
...jim


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar control Marcus Excel Discussion (Misc queries) 1 December 5th 07 07:53 AM
Calendar Control 11.0 MCorn Excel Discussion (Misc queries) 1 August 3rd 05 06:04 PM
Calendar Control: Can't exit design mode because control can't be created Rone Excel Programming 0 May 24th 04 04:01 PM
Calendar Control 9.0 Brad[_10_] Excel Programming 3 December 15th 03 06:39 PM
calendar control Asif[_3_] Excel Programming 8 November 30th 03 05:48 PM


All times are GMT +1. The time now is 07:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"