any alternatives to ms access datepicker

[mdavid]

Hi, Need a a DatePicker for selecting Date of Birth, the one that comes with access doesn't seem very practical for selecting dates years in the past.
Was wondering if there's any ready alternatives that allow selecting from day, month, year dropdown lists or would I have to code something like that myself?

Thanks for any help


David

[moke123]

I'm sure there are plenty of examples out there.
Here's one that I use which has been modified from the original by IslaDogs and myself.

datePicker.zip

[mdavid]

This is great, exactly what I had in mind.
How would I transfer it to a form in my access database?

Thanks
David

[isladogs]

Just one line of code needed. For instructions, see http://www.mendipdatasystems.co.uk/b...ker/4594398118

[mdavid]

Thanks Colin, I followed your instructions imported frmDatePicker, modDatePicker, named the text box txtDate and put InputDateField txtDate, "Select your date of birth"
into the click event, but when I try it I get the default access DatePicker not yours.
What am I missing?

[isladogs]

All sounds fine to me.
I've never had that problem, but you could try changing the Show Date Picker property to Never.

[mdavid]

Yes that took care of it, works perfect.
Thanks for your generosity.
David