No Object Error

[Fakhruddin Zavery]

Hello,

I had my access daatabase on a Win 2003 /Office 2003 Pro System and
everything was working fine. I brought over the file to an XP machine with
SP2 and am getting this error when i try to open up my forms.

'There is No Object in this Control'

I know i had used a Date Picker Control on the Win 2003 Box which i might
believe is not present on the XP Machine. Is there anyway i can resolve
this?

Thanks in advance for all the help.
Fakhruddin Zavery

 

[Martin Walke]

Hi,

Unfortunately that's one of the problems with using ActiveX controls. You
need to also copy the Date Picker control (and any dependents) from your Pro
system to the Xp machine and then register the control using regsrv32

HTH
Martin

 

[Fakhruddin Zavery]

Martin any help on how to go about this will be appreciated.

Thanks and Regards

 

[Martin Walke]

I'm not sure which Date Picker you're using but basically copy the OCX file
from the Pro machine to c:\winnt\system32 directory on the XP machine. Then
run regsvr32 with:

regsvr32 c:\winnt\system32\<datepicker.ocx> ' ignore the <> and enter
the correct filename instead e.g. regsvr32 c:\winnt\system32\mscomct2.ocx

If there are no dependents for the Date Picker then your application should
now work. Deciding what the dependents for an OCX can be problematic but
we'll approach this one step at a time ;-)

Martin

 

[Fakhruddin Zavery]

Thanks Martin,

Will give this a try in the office tomorrow and hopefully it should solve
the problem.

Thanks and Regards
Fakhruddin

 

[Tony Toews]

Martin any help on how to go about this will be appreciated.

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month
Calendar derived directly from the Common Control DLL. There are
links to several downloadable calendar forms at my website. As these
are forms you can also do anything with them you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Fakhruddin Zavery]

Thanks guys, i managed to get the datepicker ocx which was mscomct2.ocx and
register it successfully on the other machine. My database works just fine.

Thanks for both of your inputs.

Regards
Fakhruddin