MS Access 2010 need MS Access 2003 Calendar Control
Posted on 2011-05-03
I have a database written using MS Access 2000 that will not open calendar items under MS Access 2010. I have tried registering MSCAL.OCX using regsvr but that doesn't seem to help. The debugger shows the problem with the "Date" function below:
Private Sub Form_Load()
' Enter parameters in BeginningDate and EndingDate text boxes when
' form is loaded.
Me!SelectDate = Date 'Now()
Me!BeginningDate = DateSerial(Format(Date, "yy"), Format(Date, "m") - 6, 1)
Me!EndingDate = Date
I previously added references that cleared up the error as it occurred elsewhere in the program, but for some reason the calendar control stalls on that same statement.