Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dtpicker on a form 1

Status
Not open for further replies.

zevw

MIS
Jul 3, 2001
697
US
I have the file mscomctl.ocx in my system32 directory for Access2002 but I cannot find dtpicker in the ActiveX controls to insert in my form. any ideas why, and how to get to see it!

Thanks in advance for your help!
 
Search for MSCal.OCX and try registering it. Should be in the same directory as Office. The Activex' name is Calendar Control(no MS attached)
 
Sorry minusm, but you are referring to a Calendar Control, which is something different.
Zevw wants a date-time picker. So he needs a reference to
Microsoft ActiveX Data Objects library
Then you should find Microsoft Date and Time Picker Control in your ActiveX tool list.

Cheers,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:
 
There is a file on my website called dtPicker that uses the dtPicker api to create a date picker.
You need to run the code in the module to display it.
Let me know if you want help modifying the code to fit your situation.

Ben

----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
rockband.gif
NoFX-The Decline
----------------------------------------------
 
Thanks all, for your help.

Ben you have helped countless times.
Thanks Dean I got the file that is what I needed.

I Installed visual SourceSafe 6.0 with Service Pack 5 which comes with the file Mscomct2.ocx and then I copied it to my system32 directory and registered the ocx.

Now my question is, I"m trying to get the value from DatePicker with the following code, and it is not Changing the Date Field in my form with the Value selected through DatePicker.

This is the code:

Private Sub DatePicker_Click()

Me.DateField = Me.DatePicker.Value
Me.DateField.SetFocus

End Sub

I tried to debug, when I click on a date in datepicker it does not even go into this event procedure. Is it something else?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top