A Better Date Picker
HTML-код
- Опубликовано: 8 сен 2024
- This video compares the built-in Access date picker control with a better alternative.
The replacement date picker is not an Active X control and is quicker and easier to use. It can be used with both 32-bit and 64-bit Access.
For further information & the FREE better date picker app, see my article: www.isladogs.c...
TIMES:
0:17 Example application comparing both types of date picker
0:48 Access date picker introduced in Access 2010 to be 64-bit ready
1:11 DEMO - Access date picker on bound control - 3 clicks to select date
2:02 Can change months one at a time. Cannot change year independently
2:28 Unbound control - need to format textbox as date to use Access date picker
3:11 Date picker properties
3:43 Better Date Picker: larger / easier to read / fewer clicks / can change month & year easily
4:42 Better Date Picker also easy to use with unbound control
5:02 VBA code for textbox with better date picker control - 1 line of code
6:08 Module & calendar form code
6:46 Change language in Windows regional settings. Date format & language updated automatically after restarting Access. DEMO English UK / English US / Italian / Greek / Japanese
10:12 Download better date picker app (free)
Thank you. Not sure yet if it will fit in with what I'm doing but I will make a donation once I've sorted out Bcard.
Currently in Canada and it doesn't like my location.
Thanks Andrew
thank you sir. you are just great!!!!!
:)
You’re welcome. Glad you found it useful. The latest version also includes automatic form resizing
🎉 thank you!
You’re welcome. Hope you find it useful
thank you very much , that helps a lot
Glad you like it
You’re awesome. Thanks you.❤
Glad you like it!