Solved

VBA Controle Ellements problem

Posted on 2000-04-03
5
425 Views
Last Modified: 2010-07-27
***********VBA Only*********************
How can i call upon a controle ellement
from a external library, without installing the whole VB6 Pro package.

****************************************
My problem:
I wrote a lot of macro´s, witch all had to use some date-field.
Because there are a lot "DUMB" users with itchy trigger fingers, i chose for the use of DTPicker (mscomct2.ocx)
on my computer it runs great, but when i install it on another computer i manually have to assign the library file.
And because there are a lot of roming users and i´m don´t have that mutch time to configure all the computers.

Preferably some intergrated code.
I ASK YOU for a solution!
TNX, BabyBrain
0
Comment
Question by:BabyBrain
  • 2
  • 2
5 Comments
 

Expert Comment

by:Jan_Staecker
ID: 2680579
There is no strange thing behind!

You have to build up an Installer, that ports your Version of the DTPicker to the other PC.
Then the Installer tests:
- to first time install your DTPicker,
- Upgrade the existing one with yours
- or has a newer one.

Additionally it INCREMENTS the number of applications using DTPicker by one.

Szenario:
All runs fine, but one other programm is deinstalled, it DECREMENTS the numer of uses of the OCX. If the number is 0, nobody uses the OCX and the file can be deleted.

THIS IS COM. So you need to install.

With VBA used from Microsoft Office, you can use (and buy) the
- MOD (Microsoft Office Developer Toolkit - Office 2000)
- ODT (Office Developer Toolkit - Office 97)
- ADT (Access Developer Toolkit - Office 95)

Different Names but each time the same Product for the Office. There is an Installer in the Toolkit (and also the licence (*.lic-Files) to distribute the CommonDialog, CommonControls, etc..)

If you have any VB, you can also build up an installer with the Package and Deployment Assistent.

Bye Jan





0
 

Author Comment

by:BabyBrain
ID: 2683883
Tried it already and it didn´t work.
That´s another problem.
0
 
LVL 2

Accepted Solution

by:
JetScootr earned 100 total points
ID: 2706267
I've had similar problems, we manually hacked the Setup.lst and pointed the DLLs and OCXs to the $APP directory instead of the windows directory.   Then running the install on the user's machines appears the same as before, but the files are copied to the application's directory.  Now the DLLs are considered to be different (because of the different location), even if they're bytewise identical.
0
 

Expert Comment

by:Jan_Staecker
ID: 2706677

I answer serious Questions at www.askme.com.

Here on this site I will *NEVER* answer anything again! I don't like the system!

Bye Jan
0
 

Author Comment

by:BabyBrain
ID: 2721871
Here are the points.
Tnx, it worked fine, have a nice day!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

823 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