date picker; Access 2007

[dlazenby]

My date field on my form has a default date picker. It is a good control if
looking for dates within a 12 month time-frame.
I want to use it to help enter birth dates. The problem with the default
date picker is that I can advance/go back only a month at a time. You also
can't just hold down the right or left month key to continuously advance; you
can only advance a single month with a single mouse click. This obviously is
a problem if the date is in another year because I can't easily "jump" to
another year. So if the person was born 50 years ago I would have to scroll
back 50 times 12 months or 600 mouse clicks.
Please advise.

 

[John W. Vinson]

My date field on my form has a default date picker. It is a good control if
looking for dates within a 12 month time-frame.
I want to use it to help enter birth dates. The problem with the default
date picker is that I can advance/go back only a month at a time. You also
can't just hold down the right or left month key to continuously advance; you
can only advance a single month with a single mouse click. This obviously is
a problem if the date is in another year because I can't easily "jump" to
another year. So if the person was born 50 years ago I would have to scroll
back 50 times 12 months or 600 mouse clicks.
Please advise.

You might want to consider using three combo boxes for the year, month
(number), and day respectively. You can use VBA code using the DateSerial()
function to combine them into a date.

John W. Vinson [MVP]

 

[dlazenby]

John,
Thanks for your reply. I had not thought along those lines. I could
certainly do that. I was also thinking that a calendar control would also
work but did not know if they were getting away from ActiveX controls; also I
didn't know if Access 2007 came with a calendar control. Your thoughts please.

 

[Stephen Lebans]

I* do not have A2007 installed so this is just OTTOMH:
I believe Access uses the standard MonthCalendar class. If so, simply right
click over the Month or Year displayed in the Calenda to select a different
Month/Year.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[missinglinq via AccessMonster.com]

Why not use something like MSCAL.Calendar.7, or it's 2007 equivalent? The
Year and Month each are drop down boxes for selecting.

 

[dlazenby]

I agree, it seems that I should be able to just right click or left click on
the month or year to change month or year but I can't. I was able to
implement Allen Browne's calendar control. Thanks for your input.

 

[dlazenby]

Thanks for your reply. I was able to implement Allen Browne's calendar control.

 

[UpRider]

PGup and PGdown will scroll thru that calendar faster than Warp 9 !

 

[dlazenby]

Uprider,
Thanks for the reply. It is very fast, but it still scrolls a month at a
time. I like Allen Browne's calendar much better you can scroll (quickly)
through the years.