Solved

VBA Controle Ellements problem

Posted on 2000-04-03
5
428 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA : retain and exclude values based on a config sheet and multiple parameters 5 69
Access 2013 combo box not working 3 76
Copy a row 12 75
2 Global Vars, 1 List Box 4 34
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

751 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