there is no object in this control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fredloh@gmail.com - 27 Oct 2007 14:28 GMT

i have a microsoft date and time picker on a form. when i open the
form on the pc where the form was created, the form opens and display
the control properly. however, it opens just fine in some other pc and
not fine in some other pc.

in the pc where it is not working properly, before the form opens,
there is an error message "There is no object in this control." the
form then opens and in place of the control is a white rectangle.

also, on the pc giving the problem, when i import the form into a new
database. i get the error message "There was an error loading an
Activex control on one of your forms or reports".

all the pc runs windows XP. there are no missing reference and the
control name appears in the activex register list. all the access
version on all the pc is 2002.

how do i resolve this problem? any help is appreciated.

Reply to this Message

Tom van Stiphout - 27 Oct 2007 15:10 GMT

This is the normal behavior when an activex control is not present or
not properly registered on the target machine.
ActiveX controls don't require a reference and are not necessarily
installed with Windows or Access.

Proceed as follows:
On your dev computer design the form, select the control, and inspect
the Class property. It will say something like "MSComCtl2.DTPicker.2"
This tells you the control is likely implemented by mscomctl2.ocx.
Copy that file to the target machine, and in a command window run:
regsvr32.exe <path_to>mscomctl2.ocx
This registers the control with Windows.
Then try again.

Note: some controls require a license fee to be distributed, and
others are more complex to install. If you have many machines to
maintain, you should look into creating a setup program.

-Tom.

>i have a microsoft date and time picker on a form. when i open the
>form on the pc where the form was created, the form opens and display
[quoted text clipped - 14 lines]
>
>how do i resolve this problem? any help is appreciated.

Reply to this Message

fredloh@gmail.com - 31 Oct 2007 16:02 GMT

> This is the normal behavior when an activex control is not present or
> not properly registered on the target machine.
[quoted text clipped - 34 lines]
>
> >how do i resolve this problem? any help is appreciated.

thanks for the help. the registration help fix the problem. what's
interesting though is that some pc don't give the error message but
still show the control as a white box, i.e. before the registration.

Reply to this Message