Calendar Sudden Error

[Debbie]

Hello Access Community,
We have A2003 and have been using the calendar control forever without any
problem. All of a sudden whenever the calendar is opened, we get the
following error:
Method 'Value' of object '_CustomControl' failed.

If I click on the debug button, the code errors at the following line:
mctl.value = Atx_Calendar.Value

mctl is defined as an access control

No one has touched this! We have several databases and it seem to be a
problem in every one of the databases. I even tried creating a new database
and the same thing happened. I checked the reference libraries and they are
fine. I'm stumpted. Does any one have an idea of what could be causing this?
Thank you,
Debbie

 

[Arvin Meyer [MVP]]

The calendar control is an ActiveX control that is occasionally unstable.
This is particularly true if your database (and calendar control) were
upgraded from an earlier version. My advice would be to delete, then rebuild
the control's presence on the form. Be sure to save the code in a text file
first. Make sure the form is free of any calendar code, then compact the
database, or import everything into a new, empty database file. Then rebuild
your calendar and paste the code back in before compiling.

If you still have problems, I have a calendar form that's built in native
Access that's been running perfectly in all versions since 1994. Have a
look:

http://www.datastrat.com/Download/Calendar2K.zip

 

[Debbie]

Arvin,
Wow, that was quick! Thank you so much, I was afraid you were going to say
that. I think you are correct because nothing else worked. I'll give it a
try. Thanks so much for confirming it. Take care,
Debbie