[AccessD] Create object

Well basically because this is the smartest bunch of folks I know, and this
is a VBA question.  It is specifically trying to open 3DFTP but the question
would be the same for opening Excel, Word etc.  I assume that they would
react the same way.

I will look at that resource though. 


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 Gustav Brock
Sent: Monday, November 20, 2006 7:22 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Create object

Hi John

I have no solution for you, but why not address support at
support at sitedesigner.com

/gustav

>>> jwcolby at colbyconsulting.com 20-11-2006 13:01:24 >>>
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