[AccessD] Create object

Jim Lawrence accessd at shaw.ca
Mon Nov 20 15:17:08 CST 2006


Hi John:

I think it is like Excel in which you can open a number of separate sheets
but if you quit one they all quit. You can close one though... but in
reality it is all the same application...

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, November 20, 2006 11:36 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Create object

Well... I can open multiple instances manually.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, November 20, 2006 12:26 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Create object

Hi John:

The problem would appear to be with 3D-FTP which is designed to only open as
a single instance, per computer....

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, November 20, 2006 4:01 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Create object

I am trying to open multiple instances of 3DFTP and assign each instance to
a different class instance inside of Access.  When I use the syntax:
 
'
'In class header
'
Private mFtpXObj As Object ' FtpXObj

    '
    'In init function
    '
    'Start 3D-FTP loading, if not already running
    Set mFtpXObj = CreateObject("FTP.API")

The first class instance correctly opens 3DFTP but the second class instance
does not, it simply gets a pointer to the already opened 3DFTP instance.
 
AFAIK I can't use the NEW() syntax since I don't have early binding, IOW I
don't have a clue what FTP.API actually is and therefore can't reference it
in Access.  According to the help file, CreateObject is supposed to open a
new instance of the object anyway so I really should be able to do this.
 
Any thoughts?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list