"Can't move focus..."

[DejaVu]

I have a program that uses the Microsoft Date and Time Picker to select a date. When I put my macro on another users computer I get an error message that says: "Can't move focus to the control because it is invisible, not enabled, or of a type that does not acept the focus."

If I go to look at the userform, it does not have the drop down calendars (DT Picker) that I put on it.
It works fine from my computer, but I can't find what's different about the other computer not to accept the DT Picker.

Any ideas??

DejaVu

[Tom Ogilvy]

The problematic computer probably doesn't have the Microsoft Date and Time
Picker installed or your reference to it is invalid.

On that computer, after the error, go to Tools=>References in the VBE and
see if you don't see a reference marked as MISSING - specifically the
reference to the Microsoft Date and Time Picker.

--
Regards,
Tom Ogilvy

"DejaVu" <DejaVu.1w6omm_1128103513.0699@excelforum-nospam.com> wrote in
message news:DejaVu.1w6omm_1128103513.0699@excelforum-nospam.com...
>
> I have a program that uses the *Microsoft Date and Time Picker* to
> select a date. When I put my macro on another users computer I get an
> error message that says: "-Can't move focus to the control because it
> is invisible, not enabled, or of a type that does not acept the
> focus-."
>
> If I go to look at the userform, it does not have the drop down
> calendars (DT Picker) that I put on it.
> It works fine from my computer, but I can't find what's different about
> the other computer not to accept the DT Picker.
>
> Any ideas??
>
> DejaVu
>
>
> --
> DejaVu
> ------------------------------------------------------------------------
> DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
> View this thread: http://www.excelforum.com/showthread...hreadid=472172
>

[DejaVu]

Thanks for the reply Tom - But I'm still not having any luck.

Here is what I tried. I opened up the form from my computer (where the DTPicker works) and opened up Tools > Additional Controls.
In Additional Controls I found Microsoft Date and Time Picker Control 6.0 and noticed it comes from C:\\WINNT\system32\mscomct2.ocx (Windows 2000).
I copied this ActiveX control to the other users computer, but I still can not add the DTPicker control.

Any other ideas?

DejaVu