No Object in this control Access Microsoft Control

Posted on 2006-06-07
Last Modified: 2012-05-11

I have an access 2003 database (service pack 2) with which i am trying to create a calender on a form using the "microsoft date and time picker control 6.0 (SP4)". As long as i only open the form that has the calender on my computer there is no problem.

But as soon as i open the form on another computer, i loose the control for the calender.
I installed service pack 2 on this pc. Which then resulted in an error message informing me that there was a missing reference for "miscrosoft windows common controls-2.6.0 (SP4)", file "mscomct2.ocx" was missing from "c:\windows\system32\". So i copied the file over from another computer but now i am getting the error message "there is not object in this control" whenever i try to open the form with the calender on it.

Once doing this if i try to open the form on my original computer the control is no longer there, just an empty textbox.
Any ideas why this is happening?

Once i have completed this database it is going to need to be run off multiple people's computers.
Is there any way of coding this problem into a module so i can aviod going to each computer to fix this??

Thanks in advance.

Question by:Sailo100
    LVL 65

    Expert Comment

    This other PC, does it like run win2k? references may be broke
    failing that, that ocx was not installed

    u cant just copy an ocx, u have to register it as well - use something like regsvr32


    regsvr32 c:\windows\system32\mscomct2.ocx


    Author Comment


    I have registered the ocx as you suggested but i still dont get the "microsoft date and time picker control 6.0 (SP4)" in the "more controls" toolbox, when trying to create the calender.

    Both computers run microsoft xp pro.
    LVL 65

    Accepted Solution

    try this
    in forms design

    select Insert/ActiveX control

    then see if u can pick it from there

    LVL 84
    In addition - the Calendar control is very prone to versioning troubles, and since you're deploying this to others you'd be well advised to get away from that control (and the File Open/Save dialog as well). There are many alternatives, from using a form with all native Access controls to using API calls to generate your calendar. Tony Toews has collected some of the best here:

    Author Comment


    Sorry in the delay in accepting correct answer and closing the question ...

    Thanks everyone for your input, rockiroads i found the control using Insert.
    LSMConsulting didnt know that access controls were prone to problem, will be looking into it moving away from them


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now