Solved Trigger a control's datepicker with a separate button

[Richard Horne]

Is it possible to have a control - formatted as a date - have its datepicker popup when a separate button is pressed?

Basically I want to put a date field on a form with a calendar icon next to it. When the calendar icon/button is clicked I want the datepicker to appear.

I know you can just click into the date field and the datepicker will popup automatically but I've been asked to build the form this specific way if possible.

 

[arnelgp]

you can have a Command button on the form.
on the Click event you add this code:

Private Sub Command1_Click()
Me![theDateTextbox].SetFocus
DoCmd.RunCommand acCmdShowDatePicker
End Sub

 

[moke123]

Better yet, you can make your own date picker.

Date Pickers, Calendar Controls, and Calendar resources

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...

www.access-programmers.co.uk

 

[Richard Horne]

you can have a Command button on the form.
on the Click event you add this code:

Private Sub Command1_Click()
Me![theDateTextbox].SetFocus
DoCmd.RunCommand acCmdShowDatePicker
End Sub

Oh as simple as that. I'd already set focus, didn't realise that's all I needed to do.

Thanks arnelgp