"Can't move focus..."
 

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

"Can't move focus..."
 

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" wrote in
message ...

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

"Can't move focus..."
 

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

--
DejaV
-----------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...fo&userid=2262
View this thread: http://www.excelforum.com/showthread.php?threadid=47217