Update, Version 2008-08-11-0 (Supercedes Version 2007-05-25-0)

Improvements:
Now there are 3 Calendar Styles: Mini-Month, Whole-Year, and Events-Months.
The Date-Picker Function is redesigned to minimize the amount of customization that must be done when the tool is reused elsewhere.
Double-Click works in Events Months.

-------------------------------------------------------------------

I wrote these calendar tools as drop-in forms for any database where I need a date picker.

These are configured for 2003, but they will should work in all other versions too once the References are set up. Search for the word References in the code to learn more.

Contains:

1. Example of a straightforward date picker.

This uses a popup form called "CalendarPopup".
Keyboard shortcuts:
Days: Cursor Up, Down, Left, Right.
Months: PageUp, PageDown.
Years: Shift PageUp, Shift PageDown.
Today: Home.
Return or Space to save selection & close.
Escape to Close without saving selection.

The mouse works too, but I'm all about the keyboard shortcuts, because with them you can zip in, select, and zip out in a second or two. If there is a faster way to pick dates, I haven't seen it.

2. Example of a Scheduled-Events-Table tool that uses the Events Calendar.

This uses a popup form called "CalendarEvents" which has everything that "CalendarPopup" has, plus the "Description" field of the "CalendarEventsTable" records appears in the context of the calendar. It allows you to change the overall width and height of the calendar. You can go into the module and permanently change the values, if you know how many twips tall and wide you want it to be on your particular display.

Each Record in the Sample Table has two set-able Dates: DateDue, and DateDone. I use this to track my future Checking Account transactions, because they are a mix of Manual and Automatic payments, making then sometimes tricky to keep track of. This tool helps me predict exactly what payments are due, and whether they got paid, which prevents me from missing payments, and accidently making double-payments.

Click on the Datasheet Option Buttons to use the Date Picker to automatically populate the spreadsheet with the Dates you select.

Enjoy. Let me know if you like it.

It has been awhile since I posted an update to my Multi-Calendar Date Picker.
Simplified the popup call, it's just two lines of code long now.
Added calendar-format picking buttons to the top left of each calendar.
There's lots of Date Pickers out there. This is the only one I use. It behaves the way I want it to.

This post has been edited by gary84: Nov 13 2011, 11:54 AM