Date Picker

[RussG]

In VB6 there is a control called DTPICKER which allows the user to click a drop down arrow and select a date. Is this control available in Access? I can't find it , but maybe I'm looking in the wrong place.

Thanks

Russ

[This message has been edited by RussG (edited 04-16-2002).]

 

[David R]

Isn't there a DateTimePicker? Something like that, see if you can find more about it in the archives. I've never used it personally but I know I've seen something along those lines...

HTH,
David R

 

[paulhenley]

Russ,

I have just spent sometime working with this and I am reasonably happy with the result.

On your Toolbox Toolbar there is an icon with a hammer and spanner. Click this and it will give you a list, scroll down but beware that the Date Time Picker is call "Microsoft Date & Time Picker"

Hope this helps

 

[TheOx2K]

Under the same icon there is a CalenderControl button that shows a calender.

It has no on click function by you can add that in VBA.

 

[paulhenley]

Sorry to "hijack" Russ's Thread, but could you please show your VBA that has the on click function, because I could not get it to work

Many thanks

 

[Rich]

Private Sub SetDate_Click()
With CodeContextObject
If (IsLoaded("Diary")) Then
txtDate = SelectDate.Value
DoCmd.GoToRecord , "", acNewRec
Forms![Diary]![Appointments subform].Form![AppDate] = Me.txtDate
Forms![Diary]![Appointments subform3].SetFocus
DoCmd.Close
End If
End With
End Sub

 

[ListO]

Russ

I believe the date picker control you're seeking is part of the Access Developer's upgrade. I have the upgrade, and I have the datepicker (which I don't think I had before the upgrade). [Unfortunately, there's no easy way I see to determine if a control is part of the Developer's kit, or part of the 'regular' version].

-Curt

 

[RussG]

Thanks all for your help, I have located the Date Picker control and am experimenting with it.

Thanks again.

Russ