How can I switch back and forth between an MS Access VBA Application and a VB6 application?

I haven't had any luck with searching the help files or trying activeWindow.Caption, Application.<whatever shows up>, or
windows(filename).Activate

I will need to make the the inactive application invisible.

I will also need to transfer data between the two applications. I was planning to do this via data I place into a table. If you have
some other ideas, I'd appreciate them, too.

TIA
Mark

Does anyone have any ideas on how to switch between Access VBA & VB?

> How can I switch back and forth between an MS Access VBA Application and 
a VB6 application?

I haven't had any luck with searching the help files or trying 
activeWindow.Caption, Application.<whatever shows up>, or windows
(filename).Activate

I will need to make the the inactive application invisible.

I will also need to transfer data between the two applications. I was 
planning to do this via data I place into a table. If you have some other 
ideas, I'd appreciate them, too.

TIA
Mark

I am unclear on what exactly you are trying to do..
in this instance, vba is the development environment
behind ms access, and vb6 is application in and of itself.

are you talking about coding in the vba, and or, vb environment?

can you be a little more clear about what you want to do..

later,
bware

-----Original Message-----
From: Mark [mailto:tek_mark@h...]
Sent: Wednesday, January 22, 2003 1:18 PM
To: Access
Subject: [access] Re: switching between applications


Does anyone have any ideas on how to switch between Access VBA & VB?

> How can I switch back and forth between an MS Access VBA Application and 
a VB6 application?

I haven't had any luck with searching the help files or trying 
activeWindow.Caption, Application.<whatever shows up>, or windows
(filename).Activate

I will need to make the the inactive application invisible.

I will also need to transfer data between the two applications. I was 
planning to do this via data I place into a table. If you have some other 
ideas, I'd appreciate them, too.

TIA
Mark

Thanks for your reply.
I have two complete compiled applications:
    One is an Access mde program.
    The other, created independently, uses VB6 as the front-end .exe with
Access as the backend database.
    The backend tables are quite similar.

I want to merge their functionality with both applications able to share the
same database.

I will need to have the .mde start the VB6.exe. After it starts up, the
VB6.exe will terminate and stay resident

I also would like to keep the code independent. (That is, the VBA-mde code
stays as VBA the way it is except for a new interface routine, and the VB6
code stays as a separate .exe compiled from the VB environment. Both access
the same tables, queries, forms, and reports.)

----- Original Message -----
From: "bwarehouse" <bwarehouse@y...>
To: "Access" <access@p...>
Subject: [access] Re: switching between applications


> I am unclear on what exactly you are trying to do..

Lookup Shell function and Using Automation to Control a Run-Time
Application topics in Access Help.

Hope that helps...

____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

>>> tek_mark@h... 23/01/2003 1:51:23 >>>
Thanks for your reply.
I have two complete compiled applications:
    One is an Access mde program.
    The other, created independently, uses VB6 as the front-end .exe
with
Access as the backend database.
    The backend tables are quite similar.

I want to merge their functionality with both applications able to share
the
same database.

I will need to have the .mde start the VB6.exe. After it starts up, the
VB6.exe will terminate and stay resident

I also would like to keep the code independent. (That is, the VBA-mde
code
stays as VBA the way it is except for a new interface routine, and the
VB6
code stays as a separate .exe compiled from the VB environment. Both
access
the same tables, queries, forms, and reports.)

----- Original Message -----
From: "bwarehouse" <bwarehouse@y...>
To: "Access" <access@p...>
Subject: [access] Re: switching between applications


> I am unclear on what exactly you are trying to do..


This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.