How to Retrieve Data From Access Calendar Control

The calendar control is an ActiveX control added to a form in an Access database. This control can be used to display the calendar only or it can be formatted to store information in the underlying table. In order to retrieve data from the calendar control, you must set the source field for the calendar. Once the calendar is storing information in the table, you create a query to retrieve this data from the table.

Instructions

Format Calendar Control

1. Open your Microsoft Access database. Right-click your form or report. Choose "Design View" from the list of options.

2. Click the "Design" tab. Right-click the calendar control and select "Properties." Select the "Data" tab.

3. Click the drop-down box next to "Control Source." Choose your table field you want to store the data.

4. Save and close the form.

Create a Query

1. Click "Create" on the top menu. Choose "Query Wizard" from the "Other" group. Select "Simple Query Wizard." Click "OK."

2. Click your table in the drop-down box. Move the calendar control field to the right box by selecting it and pressing the ">" arrow. Add any other additional fields you want to go in your query. Click "Next."

3. Click the radio button next to "Detail" and press the "Next" button.

4. Name your query. Click the radio button to open the query. Click "Finish." The query will retrieve data from your calendar control field.

References

• "Access Help"; Introduction to Queries; Microsoft; 2010
• "Access Help"; Set Default Values for Fields or Controls; Microsoft; 2010