Mendip Data Systems
Database applications for businesses and schools
Example Apps for Businesses, Schools & Personal Use
Version 1.0 Updated 30/01/2018 Approx 90 kB
This is a replacement date picker with no Active X controls and can also be used in 64-bit Access.
It was originally posted in this thread at Access World Forums in May 2017
The calendar form is loosely based on open source code by Brendan Kidwell from 2003 which can be found here: http://www.glump.net/content/accessdatepicker/
However, I've made extensive changes to the appearance of the calendar form
If all you want is a visual calendar, it will certainly do that
However, its main purpose is to input a date in a form textbox
All you need for that is one line of code in the textbox click event:
Code:
A Better Date Picker
Click the image to view a larger version ...
Screenshots
CERT Version 1.43
Private Sub txtDate_Click()
InputDateField txtDate, "Select a date to use this on your form"
End Sub
The string "Select a date to use this on your form" is used for info on the form and can be adapted to suit
To use, copy frmDatePicker & modDatePicker to your own database
Ignore frmMain - its only needed for the example app
Click to download: Better Date Picker (zipped)