Nifty Date Picker
There are some excellent date pickers available on the internet. So why should you use mine?
First of all I’ve included details of my thought processes when I constructed it, including where I went wrong! This in itself will prove useful for anyone who wants to build stuff in MS Access.
It also gives you a very good handle on it, particularly if you want to modify this nifty date picker for your own particular use. I have also included a presentation, and a YouTube explaining how it works.
If that’s not enough, then watch this space! This is just a beginning, I intend incorporating this “Nifty Date Picker” (Calendar Control) with my “Nifty Call Called” Class Module. The combination of the two will add some sophisticated functionality with benefit of ease of use.
With the class module added, you just need to call the Pop-Up calendar form “Nifty Date Picker” from any control and it will just work. It will take the caption from the Controls label and use that as the caption for the popup calendar form without you doing a thing! No coding!
Simulated After Update Event
By adding a simple piece of VBA code to your calling form, then the calendar form will be able to simulate the afterupdate event of the control it is associated with. This means if you have two dates, a person’s date of birth, and today’s date, then the code will automatically calculate the person’s age without you having to press any other button. I haven’t seen this functionality anywhere else.
Other benefits, the class module is a class! In essence it’s a very simple class, plus I’ve done a playlist on YouTube here which runs through the functionality of the class module and also how to associate it with your own pop-up form.
DATE PICKER for ALL VERSIONS of ACCESS
Video 1 (18:39)
I demonstrate in this YouTube video “Nifty Date Picker for ALL Versions of MS Access” — https://youtu.be/q1syYwHJVwI — I show you how to put together your own Date Picker Form to create yourself a Nifty Date Picker! Why? Well a lot of code examples are only available in the later versions of MS Access (accdb). This means the example won’t work in earlier versions of MS Access!
I realised this applied to my recent Nifty Date Picker Form, it won’t work in older versions of MS Access. However; I suspect the VBA code will.
You can download the VBA code BELOW and then construct the MS Access Form following the YouTube video instructions… “Hey Presto” You should end up with a nice datepicker that will work in your version (ANY VERSION) of MS Access.
Now I’ve completed this video explaining how to build the form yourself, I will remove the FREE download option. That is, I will remove the ability to get the code for free with a coupon code. So this is your last chance to get a copy of my Nifty Access Calendar Form – Date Picker!
Video 1 (18:39)