• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1070
  • Last Modified:

Trying to use the DTPicker Control in Excel

I have developed an Excel app that uses the DTPicker control which is part of mscomct2.  When I distribute the app to other workstations, it will not load.  I have run REGSVR32 C:\Windows\system\mscomct2.ocx successfully and even rebooted.   I have even insured that the Microsoft Windows Common Controls is an active reference.  

Any help or clues?
0
jbugara
Asked:
jbugara
  • 4
  • 2
1 Solution
 
1WilliamCommented:
On one of the troublesome pc's, did you open Access and confirm the active X control was available?  What operating system(s) are you running?
0
 
jbugaraAuthor Commented:
I am attempting to run the application on some Win98 machines running Office 97.
0
 
1WilliamCommented:
Just a confirmation,
<On one of the troublesome pc's, did you open Access and confirm the active X control was available?  >
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
jbugaraAuthor Commented:
The application is driven from Excel and not Access.  When I go into Excel and look at the References, I can see the Windows Common Controls as an active reference.  However, when I then go to the Control Toolbox, I do not see the DTPicker control in the list of available controls.  My understanding is that the DTPicker was part of MSCOMCT2.OCX which I thought was the Windows Common Controls.
0
 
1WilliamCommented:
Sorry for the Access reference, I meant Excel.  The DT Picker is part of MSCOMCT2.OCX.
I ran a few tests.  I created a new Excel spreadsheet, and added reference to MSCOMCT2.OCX.  I then Opened a new form, and then the toobox.  DT Picker was not in it, so I added it.  I added the control.  I then saved and sent the spreadsheet to a co-worker.  On his PC, we opened the spreadsheet, confirmed the reference to MSCOMCT2.OCX was still there.  On the form, the control was there, but not in the toolbox.  It required manual addition.
now, when I opened the form on my co-workers machine, the reference was there, the control was on the form.

Is this also what you are experiencing?  Have you found you must make the control 'available' to make your app work?  If so, you'll need to write code to check to see if the tool is in the toolbox.  If not, thenprogramatically add the tool to the tool box.
0
 
nexusnationCommented:
Hi jbugara,
This question has been abandoned and needs to be finalized (103 days since last comment).

   You can accept an answer, split the points, or get a refund. Go to
   http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access
0
 
1WilliamCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to 1William (yeah, I know its' me, but I assure you, no favoritisim)
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now