#1
|
|||
|
|||
Calendar Control Error
I wonder if you might be able to assist me with a problem with a form in a MS Word document template opens an MS Access database to collect and insert data into the Word document. As part of that process it is supposed to open a sub-form containing a calendar for picking an applicable date. The calendar used to work properly - now it doesn't.
From the initial form in the template I click a button that is supposed to call the sub-form that contains the calendar control. The calendar used to work properly, but now it does not work at all. If I try to call an empty sub-form (one in which the calendar has been removed), it works. When I add the calendar back into the sub-form and try to call it I get the following error message: "Run time error 424: Object required". When I then click on "Debug" it shows me that the error is with the sub-form that I am trying to call. I suspect that the problem is with the references. I deleted the reference to "Microsoft DAO 3.6 Object Library", then tried to add it back when this problem occurred, but I get a message telling me that there is a naming conflict. Any suggestion you can offer would be welcome. Last edited by macropod; 12-27-2012 at 12:50 AM. Reason: Split to new thread as this post addresses a different issue |
#2
|
||||
|
||||
Hi Wayne,
I have no trouble adding a calendar control, but you don't use the "Microsoft DAO 3.6 Object Library" for that - you use the "Microsoft Calendar Control 11.0", and that is added automatically when you first add a calendar control to a userform.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you Paul. I am missing "Microsoft Calendar Control 11.0". Here's how the problem arose:
I previously had MS Word templates that drew data from MS Access databases that were created in an older version of MS Office. The VBA instruction referenced an "mdb" database. When I created a new template and new MS Access database it didn't work. Another member of this forum advised me to change the VBA instruction to reference an "accdb" database, and to delete the reference to Microsoft DAO 3.6 Object Library and replace it with a reference to Microsoft Office 14.0 Access Database Engine Object Library. I did that, and I am now able to draw data from the new database. However, the MS Word form that I use to do that includes a calendar control. That calendar control no longer works. I have looked through the list of objects available to reference. I do not see Microsoft Calendar Control 11.0. I have tried deleting the calendar from the form, saving it, then re-opening it and re-inserting the calendar. It still does not work. Is there some place I can find Microsoft Calendar Control 11.0 and insert the reference manually? |
#4
|
|||
|
|||
Wayne,
Try registering the dll: Unzip the Word 2003/2007 version of mscal.ocx into C:\Windows\SysWow64 instead of C:\Windows\System32. On the Start menu, right-click the Command Prompt and choose Run As Administrator. An ordinary command prompt or Run box doesn't have the permissions needed to do the registration of the ocx.
regsvr32 mscal.ocx That will register the calendar tool. When you go into Word 2010 and start a userform, right-click the toolbox and choose Additional Controls. The calendar will be listed as "Calendar Control 11.0", and it does work. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!! | bennypryde | Office | 1 | 01-05-2012 03:33 PM |
Error when creating a calendar entry with VBA | mbodunov | Outlook | 0 | 03-10-2011 11:21 PM |
Calendar control accepts other values | JeJ | Word | 0 | 03-02-2011 03:38 PM |
Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |
Receive error cannot open this form because an error occurred in BCM 2007 | bornhusker | Outlook | 0 | 06-01-2009 10:28 AM |