"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.

 

[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 th
DTPicker works) and opened up Tools > Additional Controls.
In Additional Controls I found *Microsoft Date and Time Picker Contro
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 stil
can not add the DTPicker control.

Any other ideas?

DejaV