A replacement for the deservedly much maligned Microsoft .OCX. This implementation is entirely in code, one form and one module. The attachment contains both an Access 97 and Access 2003 version, but it imports and runs in Access 2007 and Access 2010. It will NOT work on 64-bit Access without changes to the Win API calls.

It's written as a pop-up, appearing just at your cursor position. Pick a date and it disappears in 1/2 second. The application has an additional form to show how it's implemented, with further implementation instructions. It has several options that change its appearance by adding Year and Month controls. All options are set by parameter calls to the datepicker object. You do not (necessarily) have to alter any code.

The frmCal code also provides a good example of how to include a Property Get/Let in a form. Notice that the form is not loaded explicitly. Instead, a Get just retrieves the new date value and the form loads automatically and waits for a calendar date pick.

Version 4 - of MerleDatePicker adjusts its window size according to some Windows settings. There are some good examples that demonstrates window positioning and size using the WIN32 API. Cybercow provided the Access 97 version.

Feel free to contact the author with suggestions or code breakages. I hope you find it useful.
 DatePicker.JPG ( 25.69K ) Number of downloads: 197


 MerleDatePickerV4.zip ( 149.38K ) Number of downloads: 52