Calendar Control Not listed in Available Controls ?
 

How can i make this available?

Calendar Control Not listed in Available Controls ?
 

Depends which calendar control, but the MS one is installed with Access I
believe.
Others available, including the DTPicker.

NickHK

"Coza" wrote in message
...
How can i make this available?

Calendar Control Not listed in Available Controls ?
 

OK,
Installed MSAccess and i now have the Calendar Available.
How can i get it to run when a Textbxo is Entered on a userform ?

Corey....
"NickHK" wrote in message
...
Depends which calendar control, but the MS one is installed with Access I
believe.
Others available, including the DTPicker.

NickHK

"Coza" wrote in message
...
How can i make this available?

Calendar Control Not listed in Available Controls ?
 

I would suggest, as a general approach:
Put it on the userform and make its visible property false.


In the exit event of the userform add code to make its visible property true.

--
Regards,
Tom Ogilvy



"Coza" wrote:

OK,
Installed MSAccess and i now have the Calendar Available.
How can i get it to run when a Textbxo is Entered on a userform ?

Corey....
"NickHK" wrote in message
...
Depends which calendar control, but the MS one is installed with Access I
believe.
Others available, including the DTPicker.

NickHK

"Coza" wrote in message
...
How can i make this available?

Calendar Control Not listed in Available Controls ?
 

Are you planning to distribute your workbook? If your other users don't have
the same control installed you may have problems (I accidently did that,
used the calendar control that was installed with Access and then tried to
distribute my workbook to people who didn't have Access- ouch.). If this is
just for your own use, ignore this :)

To answer your other question, some of the more experienced folks might be
able to tell you if there is an "on_enter" event for a textbox. For my
application, I put a button and a label, so I (and the other users) could
click the button to change the date. It brought up a second userform, sized
exactly to the size of the calendar control. The selection of a date on the
calendar control populated the label on the main form, and cancelling the
calendar control without an entry was handled and returned a null value.

HTH
Keith

"Coza" wrote in message
...
OK,
Installed MSAccess and i now have the Calendar Available.
How can i get it to run when a Textbxo is Entered on a userform ?

Corey....
"NickHK" wrote in message
...
Depends which calendar control, but the MS one is installed with Access I
believe.
Others available, including the DTPicker.

NickHK

"Coza" wrote in message
...
How can i make this available?