Display Date Picker in Access
Hi
In MS Access is there a way of automatically making the date picker appear when a date control has focus - ie as opposed to having to click on the date picker icon next to the control
Many thanks
In MS Access is there a way of automatically making the date picker appear when a date control has focus - ie as opposed to having to click on the date picker icon next to the control
Many thanks
What version of Access? 2007 and above have a native Datepicker control. This is controled in the Properties window for each control.
"In MS Access is there a way of automatically making the date picker appear when a date control has focus"
From a user standpoint, I suggest not doing this, as it may be more of an annoyance than helpful. If a using is just tabbing through that control(s) ... then having the picker pop will be annoying.
mx
From a user standpoint, I suggest not doing this, as it may be more of an annoyance than helpful. If a using is just tabbing through that control(s) ... then having the picker pop will be annoying.
mx
ASKER
For this particular project getting the date picker to work in this way is exactly what is required thus the reason for my question so the annoyance factor doesn't come into it.
Its Access 2007
Its Access 2007
I played with it some in A2010 ... so far can't get it do pop open ... but I have a feeling there is away.
mx
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As MX has answered your direct question, I am not seeking any points here...
The Access 2007 Calendar "Thingy" is cool, but it is terrible if your dates span large ranges...
...just try selecting a date of May 12, 2005
:-O
LOL
<getting the date picker to work in this way is exactly what is required>
FWIW, things like this are always deemed "Required", because they seem slick and or cool.
...but as MX states, users will be come frustrated because they can type in "5/12/2005" a LOT faster than they can "Navigate" to it using the control.
Again, just my 2c, as I know that the 'requirements' pay the bills,...
;-)
..and perhaps you only need fairly recent dates...
;-)
JeffCoachman
The Access 2007 Calendar "Thingy" is cool, but it is terrible if your dates span large ranges...
...just try selecting a date of May 12, 2005
:-O
LOL
<getting the date picker to work in this way is exactly what is required>
FWIW, things like this are always deemed "Required", because they seem slick and or cool.
...but as MX states, users will be come frustrated because they can type in "5/12/2005" a LOT faster than they can "Navigate" to it using the control.
Again, just my 2c, as I know that the 'requirements' pay the bills,...
;-)
..and perhaps you only need fairly recent dates...
;-)
JeffCoachman
Yes, unfortunately it's another 'partial implementation' of a feature :-(
For example ... Shift+Left Arrow (once open) SHOULD decrement the date by one year ... things like that.
mx
For example ... Shift+Left Arrow (once open) SHOULD decrement the date by one year ... things like that.
mx
<Shift+Left Arrow (once open) SHOULD decrement the date by one year>
Every day's a school day...
;-)
Jeff
see this sample db
CalendarExample.mdb