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.co.uk/better-dat...
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)
Негізгі бет A Better Date Picker
Пікірлер: 10