Solved

Object Instancing...

Posted on 2003-12-10
11
492 Views
Last Modified: 2013-11-25
I'm wanting to write an object that behaves like MS Outlook in that when I go to get a refrence to it, if it's already running it will return the running instance. Is this possible in VB? Would or Could I do this as an ActiveX Exe project?

Dim MyObject as MyObject
Set MyObject = new MyObject
'if the object is already running, I want the currently running instance. So, theoretically I might have several refrences to it.
Any Ideas?
0
Comment
Question by:Bilbo_Baggins2
  • 5
  • 5
11 Comments
 
LVL 27

Expert Comment

by:Dabas
ID: 9915303
Hi Bilbo_Baggins2:
> Would or Could I do this as an ActiveX Exe project?
Yes

Dabas
0
 

Author Comment

by:Bilbo_Baggins2
ID: 9915655
I wrote a test program... I have one property that's a string. I want to set the property in the first instance then see that string when I read the property in each new Standard EXE instance I start. The test below doesn't work right. It's starting a new instance of clsTest each time I spawn it in the standard EXE. How do I get it to return the instance of the already running class?

The ActiveX Exe project is named clsTest and has the following code:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private sName As String

Public Property Get NameOfInstance() As Variant
    NameOfInstance = sName
End Property

Public Property Let NameOfInstance(ByVal vNewValue As Variant)
    sName = vNewValue
End Property
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

The Standard Exe project has the following code:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim oTest As clsTest.clsTesting

Private Sub Command1_Click()
    oTest.NameOfInstance = "Jeff"
End Sub

Private Sub Command2_Click()
    Label1 = oTest.NameOfInstance
End Sub
'also tried createobject
Private Sub Form_Load()
    Set oTest = New clsTest.clsTesting
End Sub
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
0
 
LVL 27

Expert Comment

by:Dabas
ID: 9916039
Bilbo_Baggins2:
Is the ActiveX Exe program running in the background?

Dabas
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:Bilbo_Baggins2
ID: 9916277
>Is the ActiveX Exe program running in the background?

Yes, it's running in the background. When the first Standard exe starts it starts the ActiveX Exe if it isn't running yet.

Although the code above will start the ActiveX Exe.
0
 
LVL 27

Expert Comment

by:Dabas
ID: 9916352
Bilbo_Baggins2:
What does the instancing property for the project show?

Dabas
0
 

Author Comment

by:Bilbo_Baggins2
ID: 9916380
5 - MultiUse
0
 
LVL 27

Expert Comment

by:Dabas
ID: 9916449
Bilbo_Baggins2:
Try to change to GlobalSingleUse

IF that fails, then try one of the other settings

Dabas
0
 

Author Comment

by:Bilbo_Baggins2
ID: 9916544
that doesn't seem to work either. It still seems to be creating each new one as a new instance.
0
 
LVL 28

Accepted Solution

by:
AzraSound earned 400 total points
ID: 9916673
You need to add your ActiveX EXE into the ROT (Running Object Table).  This sample shows you how to do that:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=12319&lngWId=1
0
 
LVL 27

Expert Comment

by:Dabas
ID: 9917102
Bilbo_Baggins2:
I leave you in Azra's very capable hands!

Dabas
0
 

Author Comment

by:Bilbo_Baggins2
ID: 9917555
Thanks Azra. That's exactly what I needed.

And thanks to you, Dabas. I appreciate the effort!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

696 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