Microsoft Access: create calendar - how it works
If you want to select or view dates in Access, you must create a calendar. We explain how you can do this in Microsoft Access without any programming knowledge.
Create calendars in Microsoft Access 2007
An ActiveX control for calendars is available in this version. You can insert this into forms.
- First switch to the design view of the desired form.
- Navigate to the "Controls" group in the "Design" tab and select the "Insert ActiveX control" button.
- Select the "Calendar Control 12.0" entry from the list. The element you just selected now appears on the form.
- Click on the calendar so that it is highlighted and then select the "Property sheet" entry in the "Tools" group in the ribbon.
- To ensure that the calendar also works, select the field for the date under "Control content" in the "Data" tab.
- Now go back to the form view and click on a specific date in the calendar. This entry is then displayed accordingly in the field just selected.
Insert calendar from Microsoft Access 2010
As of Access 2010, Microsoft no longer offers a calendar control. Nevertheless, you don't have to do without a calendar.
- The SmartTools Access calendar is free of charge and provides you with a calendar for your forms.
- With this helpful extension you even get an overview of appointments and tasks.
- The current holidays and public holidays for Germany, Austria and Switzerland are also included.
- The full version of the SmartTools Access calendar includes instructions and an automatic installation program. It can be used with all versions from Access 2003 onwards.
- All you have to do to download is your name and an email address.
We will explain how to create a macro in Access in the next practical tip.