andyeastes
Registered User.
- Local time
- Today, 11:35
- Joined
- Dec 29, 2010
- Messages
- 31
Calendar control error loading events
Hello,
I have an activeX calendar.10 control on my form. It works fine on my computer but when I go to any other computer there are a few errors. First, it will not set to the default date of today. It sets to the date the calendar was added. I have deleted and re added the calendar and the day that is done is the date it will select when the database is added when the form is opened on any other computers than mine. Then when you switch to another day it gives two error messages back to back. "The expression beforeupdate you entered as the event property setting produced the following error: There was an error loading an activeX control on one of your forms or reports." This error then shows again with the same message except it is for the afterupdate event property. The weird thing about these messages is that I do not have any events or anything set up for those properties, before and after update. Also, after hitting OK for the error messages the calendar then does allow you to go to the day you want and use all functionalities that rely on selecting that date. The code to set the default date to today is in the OnOpen event of the form that the calendar is on. This is the only code on the form, or the calendar for that matter;
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
DoCmd.SetWarnings False
Me.[ActiveXCtl22].Value = Date
DoCmd.SetWarnings True
End Sub
Now, I am assuming the issue is something with missing references or registry errors. If I go to controlG, tools, references, all of the same ones are checked. None of them say MISSING. I have tried unchecking some and rechecking them and also unchecking all of them that it allows and rechecking them. I have also made sure that the three MSCAL.OCX file match the other computer that are on my computer. Also, nothing is showing up in the event log if you go to administrative tools. I cannot figure out how to debug the issue and the help items on the error message are not helping at all. I have tried to recreate the issue on my computer but it works fine and I cannot recreate it.
Any help would be greatly appreciated. I have been struggling with this, which I feel should be a small issue, for days now!
Thanks,
Andy
Hello,
I have an activeX calendar.10 control on my form. It works fine on my computer but when I go to any other computer there are a few errors. First, it will not set to the default date of today. It sets to the date the calendar was added. I have deleted and re added the calendar and the day that is done is the date it will select when the database is added when the form is opened on any other computers than mine. Then when you switch to another day it gives two error messages back to back. "The expression beforeupdate you entered as the event property setting produced the following error: There was an error loading an activeX control on one of your forms or reports." This error then shows again with the same message except it is for the afterupdate event property. The weird thing about these messages is that I do not have any events or anything set up for those properties, before and after update. Also, after hitting OK for the error messages the calendar then does allow you to go to the day you want and use all functionalities that rely on selecting that date. The code to set the default date to today is in the OnOpen event of the form that the calendar is on. This is the only code on the form, or the calendar for that matter;
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
DoCmd.SetWarnings False
Me.[ActiveXCtl22].Value = Date
DoCmd.SetWarnings True
End Sub
Now, I am assuming the issue is something with missing references or registry errors. If I go to controlG, tools, references, all of the same ones are checked. None of them say MISSING. I have tried unchecking some and rechecking them and also unchecking all of them that it allows and rechecking them. I have also made sure that the three MSCAL.OCX file match the other computer that are on my computer. Also, nothing is showing up in the event log if you go to administrative tools. I cannot figure out how to debug the issue and the help items on the error message are not helping at all. I have tried to recreate the issue on my computer but it works fine and I cannot recreate it.
Any help would be greatly appreciated. I have been struggling with this, which I feel should be a small issue, for days now!
Thanks,
Andy
Last edited: