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
kenabbottAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Ok  here you go:

Private Sub txtYourDateField_GotFocus()
    SendKeys "%{DOWN}"
End Sub
0
 
Rey Obrero (Capricorn1)Commented:
you have to use your own calendar control to do this.
see this sample db
CalendarExample.mdb
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What version of Access? 2007 and above have a native Datepicker control. This is controled in the Properties window for each control.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
0
 
kenabbottAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
Jeffrey CoachmanMIS LiasonCommented:
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

0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
Jeffrey CoachmanMIS LiasonCommented:

<Shift+Left Arrow (once open) SHOULD decrement the date by one year>

Every day's a school day...
;-)

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.