Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-26-2012, 12:28 PM
WayneCusack WayneCusack is offline Calendar Control Error Windows 7 32bit Calendar Control Error Office 2010 32bit
Novice
Calendar Control Error
 
Join Date: Dec 2012
Posts: 4
WayneCusack is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-28-2012, 04:32 AM
macropod's Avatar
macropod macropod is offline Calendar Control Error Windows 7 64bit Calendar Control Error Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 12-28-2012, 10:25 AM
WayneCusack WayneCusack is offline Calendar Control Error Windows 7 32bit Calendar Control Error Office 2010 32bit
Novice
Calendar Control Error
 
Join Date: Dec 2012
Posts: 4
WayneCusack is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 12-28-2012, 12:11 PM
gmaxey gmaxey is offline Calendar Control Error Windows 7 32bit Calendar Control Error Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,421
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

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.
  1. At the command line, enter these two commands:
cd \windows\syswow64
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.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar Control Error 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft