Nifty Date Picker
There are some excellent date pickers available on the internet. So why should you chose the “Nifty Date Picker”?
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.
Nifty Date Picker - Free!
Nifty Date Picker - For "ALL" Versions of MS Access
Video 1 (18:39)
In this YouTube video I demonstrate the Free “Nifty Date Picker” Suitable for “ALL” Versions of MS Access” I show you how to put together your own Nifty
Date Picker Form. Why? Well a lot of code examples are only available in the later versions of MS Access (accdb). This means Some examples won’t work in earlier versions of MS Access. I realised this could apply to my Nifty Date Picker it may
not work in older versions of MS Access. You can download the VBA code BELOW and then construct the “Nifty Date Picker” by following the YouTube video instructions… “Hey Presto” You have a Free copy of the “Nifty Date Picker” that will work in ANY VERSION of MS Access.
Video 1 (18:39)
Buy Tony a coffee!