MS Access sample

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi all,
I've installed xtreme calendarpro evaluation copy, but
i couldn't run the Microsoft Access sample. I am using MS Access 2003
and 2007.
The error message was : "Runtime error 438. Object doesn't support this property or method.

The line that the debugger stops at is:
Me.CalendarControl1.SetDataProvider "Provider=Access;"
I checked the reference is already there.
and from the activex toolbox i can drag the control.

If I manually type in Me.CalendarControl1. the intellisense doesnot show up SetDataProvider.

Any help would be very much appreciated.

TIA
Andi

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
andihp Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18 December 2007 Location: Australia Status: Offline Points: 2	Post Options Post Reply Quote andihp Report Post Thanks(0) Quote Reply Topic: MS Access sample Posted: 19 December 2007 at 4:33pm
	Hi all, I've installed xtreme calendarpro evaluation copy, but i couldn't run the Microsoft Access sample. I am using MS Access 2003 and 2007. The error message was : "Runtime error 438. Object doesn't support this property or method. The line that the debugger stops at is: Me.CalendarControl1.SetDataProvider "Provider=Access;" I checked the reference is already there. and from the activex toolbox i can drag the control. If I manually type in Me.CalendarControl1. the intellisense doesnot show up SetDataProvider. Any help would be very much appreciated. TIA Andi

sserge Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 01 December 2004 Status: Offline Points: 1297	Post Options Post Reply Quote sserge Report Post Thanks(0) Quote Reply Posted: 19 December 2007 at 5:29pm
	Hi Andi, As for using Calendar control within Access environment, sometimes there could be a problem with the registration of the component. Try to ignore those errors, and reinsert both Calendar and DatePicker controls to the form, with names like in VBA code: CalendarControl1 and DatePicker2. After re-inserting the control to the form, it should work properly. -- WBR, Serge

andihp Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18 December 2007 Location: Australia Status: Offline Points: 2	Post Options Post Reply Quote andihp Report Post Thanks(0) Quote Reply Posted: 19 December 2007 at 6:12pm
	Hi Serge, it works, thanks. but... if i change the date using datepicker control and clicked on refresh button but the calendar did not refresh. The other thing is if i want to add some more fields in the Event table, do we need to buy source code and modify it accordingly to be able to add more fields in the table? Big thank for any explanation. TIA Andi