Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Date picker not appearing (Access2003)

    In db there are two date picker objects (MS Date pickers). Client can see them, I can see them, new laptop with new installation of Access 2003 cannot see them.
    Error 2683 appears when attempting to reveal them.
    Does something need to be registered before these will appear (I'm thinking along the lines of ActiveX type licensing, even though these are MS Date pickers).
    TIA
    Alan
    Cheshire
    UK

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Date picker not appearing (Access2003)

    The date/time picker does not come with MS Office Pro, so it is tricky to use it in a database to be used by others. If you have the Visual Studio Tools for Office, you can create an installation package for the database that will install the necessary control(s).

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Date picker not appearing (Access2003)

    Sorry Hans and pardon my ignorance but how does MS Office Pro determine the object?
    Is it not installed from the Access 2003 installation? or does it need to be a particular option of access (developer, pro etcetera)?
    Is there no embedding applicable for this?
    Thanks
    Alan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Date picker not appearing (Access2003)

    The functionality of the Date and Time Picker control is stored in a file named mscomct2.ocx. This file is NOT a standard part of Windows or of Office Pro. It comes with various flavors of Visual Studio, and if you have one of those, you have the right to distribute the mscomct2.ocx file. You cannot embed this file in your database, it hase to be installed and registered.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Date picker not appearing (Access2003)

    Thanks Hans, again.
    I found that this was microsoft known problem. Strange but when I search MS on the original query there were no tangible usable results, however, having searched on mscomct2.ocx I found a download page at:
    http://support.microsoft.com/default.aspx?...kb;en-us;297381
    which I can direct client IT to so as to install and register.
    Job's a good 'un.
    Well done and thanks

    Alan

  6. #6
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Date picker not appearing (Access2003)

    Job WAS a good 'un, until client rang for help saying can't find/register etcetera.
    Am I right in saying:
    download CAB file,
    extract to ...temp file?
    select .inf file and select install,
    open access,
    tools>activex controls....
    register
    navigate to MSCOMCT2.OCX file
    select open
    voila activeX control is registered?

    The only reason I can think of this not happening is access rights to the system32 folder where the activex file should have been installed to.
    Alan

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Date picker not appearing (Access2003)

    Someone else will have to answer this, I don't know much about this kind of thing.

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: Date picker not appearing (Access2003)

    Actually, you shouldn't have to go through a process that complex. You should be able to simply extract the file, put it in an appropriate directory on the workstation, and then use regsvr32 to register the OCX. You may then need to set references to the file location in Access VBA editor, as it will likely have a different path, but you should be good to go. There is some question in my mind about the licensing agreement in this situation, so you may want to investigate that - you as a developer may need to have either the developer edition for OfficeXP or Visual Studio.
    Wendell

  9. #9
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Date picker not appearing (Access2003)

    Thanks Wendell,
    All seemed to go through succesfully in the end.
    re:Licensing Issue, I checked the MS side of it and the cab is freely available for download and use.
    Cheers

    Alan
    Cheshire
    UK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •