Mendip Data Systems

Database applications for businesses and schools

LogoTransparent

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

DatePicker

 

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)

Return to Example Databases Page