Welcome to the Mini Calendar Database. This database has two forms, and four modules, and one macro. The macro is an AutoExec macro which will open up one of the two forms. This is a demo form that I made to demonstrate the different ways that you can utilize the MiniCalendar form. There are five example fields. The first shows a text box that is setup for a short Date. The next textbox is set up for a long date. The MiniCalendar merely kicks out a date, but Microsoft Office programs don't care what format the date is in, it will show whatever format the Text Box, or Field is designed to show. (all dates to these programs are actually stored as a serial number, just an FYI)
The third text box was designed to show you how to implement the MiniCalendar automatically, without a command button (the other four text boxes have associated command buttons to start the MiniCalendar), this is done with the Got Focus Event. The fourth text box shows how the MiniCalendar can be presented with a specific Month and Year shown first. The MiniCalendar will show practically any month and year, though it could be modified to show only certain months/years.
The last textbox is an example of how to show a specific month first, on the MiniCalendar with a calculation based on the current month. The example I have set up starts the MiniCalendar Six months from the current month. Of course, as I stated earlier, the MiniCalendar can still show other months, but again, like I mentioned earlier, it can be changed.