Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2001
    Posts
    1

    Unanswered: Date/Time Picker Control in MS Access 2000

    I have created an Access Database using forms with some VBA code.
    I have also used the Date/Time Picker Control in some of the forms.

    The problem is that when I ran the program on another PC it goes into debug mode.

    I have traced the problem to be that the Date/Time Picker Control is not available on that installation of MS Access.

    Is there a way that I can "make it available" in that machine so that the program works and without installing / re-installing MS Access and can it be downloaded from the Net?

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    You should be able to copy the .ocx file into your system directory and then register it manually.

    Unfortunately, I can't remember what the command is to register it.

    I'm sure it had 'reg' in it's name though and it also lives in the system directory.

    Not a complete solution, but it is definately possible

  3. #3
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    I belive it is RegSrvr32 -- I have the syntax somewhere around here to put it on your right-click context menu (so you can right click a DLL / OCX / etc. and register / unregister them).
    Thanks,

    Matt

  4. #4
    Join Date
    Jan 2003
    Posts
    2

    no refresh

    i also have a problem with this date/time picker control. on each other element i can use: "on change" but the date/time picker control hasent this event. i tryed to use "on OLE refresh", but it didnt work. can somone help me?


    thanks, pyranha.

  5. #5
    Join Date
    Feb 2002
    Location
    Silver Spring, Maryland
    Posts
    74
    Originally posted by Paul
    You should be able to copy the .ocx file into your system directory and then register it manually.

    Unfortunately, I can't remember what the command is to register it.

    I'm sure it had 'reg' in it's name though and it also lives in the system directory.

    Not a complete solution, but it is definately possible

    Can you please tell me the name of the OCX component.

    Thanx

    Wango

  6. #6
    Join Date
    May 2003
    Location
    Long Beach, CA
    Posts
    1

    Smile Looking for Right-Click RegSrvr32 functionality

    Originally posted by MattR
    I belive it is RegSrvr32 -- I have the syntax somewhere around here to put it on your right-click context menu (so you can right click a DLL / OCX / etc. and register / unregister them).
    Do you have this syntax? I could really use it now. Thanks!

    myles@mylesmedia.com

  7. #7
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    Well, to register it you do regsvr32 yourDll.DLL, I can't find the right-click context menu method (which is far more convenient).
    Thanks,

    Matt

  8. #8
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: Date/Time Picker Control in MS Access 2000

    Originally posted by elbmw
    I have created an Access Database using forms with some VBA code.
    I have also used the Date/Time Picker Control in some of the forms.

    The problem is that when I ran the program on another PC it goes into debug mode.

    I have traced the problem to be that the Date/Time Picker Control is not available on that installation of MS Access.

    Is there a way that I can "make it available" in that machine so that the program works and without installing / re-installing MS Access and can it be downloaded from the Net?
    just copy mscomct2.ocx in system folder together with your access database to the pc that you want to run it. go to START - RUN and type: "REGSVR32 MSCOMCT2.OCX" in the box (without quotation mark) and press enter and enter again for the followed message box.

    DONE
    qha_vn

  9. #9
    Join Date
    Oct 2006
    Posts
    13

    Access Date Picker

    Use a date picker that doesn't need any OCX or other distributable file. See www.AccessToGo.org.uk for a good one.

  10. #10
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Date PopUp

    Attached is an example of a PopUp calendar you can try. You can modify it to also put a listbox of times and write in the time also.
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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