Microsoft Access Date Picker

15 January 2003

I've been programming with Microsoft Access for a few years now, and I've found it to be an excellent database development platform, despite its many shortcomings.

One of my pet peeves with Microsoft Access has been its lack of a built-in control or dialog box for graphically picking a date. There are some nice ActiveX controls out there you can reference from your Access programs, but this has proven to be an unreliable solution for me. I have clients running a database of mine at a few different locations, and some of them are running Access 97 while others are running Access 2000 or 2002. I can't guarantee that a particular ActiveX control is installed there, and talking them through an install or automating the install aren't easy to do.

DatePicker.mdb contains a module and a form that together implement a date picker function using only intrinsic Access controls and Visual Basic code. It should be compatible with Microsoft Access 97, Microsoft Access 2000, and Microsoft Access 2002.

Downloads
datepicker.zip (69kB)
readme.html (5kB)

(Wow, this has been up here for years without a screenshot. Oops! Here you go. 14 March 2007)