 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2007date picker; Access 2007
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. >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. [quoted text clipped - 6 lines] >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] 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. > >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. [quoted text clipped - 12 lines] > > John W. Vinson [MVP] 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.  SignatureHTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. > John, > Thanks for your reply. I had not thought along those lines. I could [quoted text clipped - 27 lines] >> >> John W. Vinson [MVP] Why not use something like MSCAL.Calendar.7, or it's 2007 equivalent? The Year and Month each are drop down boxes for selecting. SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Thanks for your reply. I was able to implement Allen Browne's calendar control. > Why not use something like MSCAL.Calendar.7, or it's 2007 equivalent? The > Year and Month each are drop down boxes for selecting. 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. > I* do not have A2007 installed so this is just OTTOMH: > I believe Access uses the standard MonthCalendar class. If so, simply right [quoted text clipped - 32 lines] > >> > >> John W. Vinson [MVP] PGup and PGdown will scroll thru that calendar faster than Warp 9 ! > My date field on my form has a default date picker. It is a good control > if [quoted text clipped - 10 lines] > back 50 times 12 months or 600 mouse clicks. > Please advise. 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. > PGup and PGdown will scroll thru that calendar faster than Warp 9 ! > [quoted text clipped - 12 lines] > > back 50 times 12 months or 600 mouse clicks. > > Please advise. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.