Step 2: A dialog box named “excel options” opens.

Step 1: Under the “file” menu, choose “options.”.

You do not have to worry about this AciveX Control in Microsoft Access 2007 and later, as a date picker/calendar will appear automantically for the user, when they put their cursor in a date field on a form. Test this code to make sure it works by closing the VBA (coding window) and opening the form and clicking on a date on the Calendar your date field should be updated.ĭelete the 'Update' Subprocedure as you do not need this from the coding window. You will also need to change the Calendar Number to coincide with the Calendar number on your form. Then, to the ‘Click’ Subprocedure, add the following code: Me!DateField = Me!Calender4Ĭhange ‘DateField’ to the name of the field that contains your date data. Scroll down and select the ‘Click’ event Ī new Subprocedure will be created as per below: Private Sub Calendar4_Click() You will need to create another event for the 'On Click' eventĬlick on the drop-down arrow in the procedure section of the VBA window (this is where the ‘Updated’ event is currently displayed), in the upper right-hand section of the window, just below the toolbars The default Subprocedure for the ActiveX Calendar Control is ‘Updated’, as indicated above, not the ‘On Click’ event.

In the ‘Choose Builder’ window, select ‘Code Builder’ and then click ‘OK’ (if prompted).Ī Subprocedure will be created as per below: Private Sub Calendar4_Updated(Code As Integer).

Right-click on the outer edge of the Calendar control and select ‘Build Event’ from the drop-down list.

The ‘On Click’ event is available we just have to access it in a different way. But, if you were to do this, you would not see an ‘On Click’ event. Normally to do this, I would suggest right clicking on the Calendar, selecting properties and then clicking on the ‘Event’ tab. To fix this we are going to add some code to the ‘On Click’ event for the Calendar. Note: the date in the date text box has not been updated.

Change to Form view and select a date on the Calendar.

Microsoft calendar control 2007 missing