Help with Calendar object

[Nick34]

I am trying to set an object variable to a calendar object that I have created on a form. I can't seem to get this. What is the syntax for referring to a calendar control???

 

[DJN]

For example, SelectDate is the name of your ActiveX calendar control. StartDate is the name of the text box. The syntax would be StartDate = SelectDate.Value. This applies for Access97

 

[Nick34]

This is the code I'm working with:

Dim oCal As MSACAL.Calendar
Dim pdCalendarReportDate As Date

Set oCal = Forms("Switchboard Subform QC&quot!ReportDateCalendar
pdCalendarReportDate = oCal.Value
Debug.Print pdCalendarReportDate

Set oCal = Nothing

The Set command is whereI am running into trouble.

 

[oharab]

Set oCal = Forms("Switchboard Subform QC&quot.ReportDateCalendar

using the bang (!) indicates the field behind the form called ReportDateCalendar, not the object on the form called ReportDateCalendar.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[Nick34]

I have tried that syntax, but am getting the error message "Type mismatch" Why is that?

 

[oharab]

Try:
Dim oCal As Object

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[Nick34]

Thank you!