By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,441 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,441 IT Pros & Developers. It's quick & easy.

Opening another Access application from an Access ap;ication

P: n/a
Hi:

I have a situation where I need to programmatically open an Access application from an
Access applications on the same system. Eventually the second application will close and
return control to the first one. They share the same data base!

For the life of me I cant make that happen.

Does anyone have any suggestions? If you do have suggestions, the more precise you can be
regarding code or functions, the more helpful it would be.

Thanks in advance

John Baker
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
John Baker wrote:
I have a situation where I need to programmatically open an Access application from an
Access applications on the same system.


Dim App As Access.Application
Set App = New Access.Application
Nov 13 '05 #2

P: n/a
Lyle:

Thanks a lot.

In real world would that translate, where "reports.mdb" is the application and is in the
same directory as the original (calling) application, as:

Dim Reports As Access.Application
Set Reports= "Reports.mdb"
Open Reports

??

Never played with this aspect of Access before so am not quite certain of the structure
and syntax.
Best

John

Lyle Fairfield <ly***********@aim.com> wrote:
John Baker wrote:
I have a situation where I need to programmatically open an Access application from an
Access applications on the same system.


Dim App As Access.Application
Set App = New Access.Application


Nov 13 '05 #3

P: n/a
John Baker wrote:
In real world would that translate, where "reports.mdb" is the application and is in the
same directory as the original (calling) application, as:


Dim App As Access.Application
Set App = New Access.Application
App.OpenCurrentDatabase "Reports.mdb"
....
We can now use App.SomeAppMethod
or
App.SomeAppObject

This will depend upon what we want to do with/in the Reports.mdb.
Nov 13 '05 #4

P: n/a
Actually, unless you're positive that Reports.mdb is in the current
directory, it's safer to use a complete path to the second database.

Remember that the current database may or not be the same directory as the
current database is in.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:X1******************@read1.cgocable.net...
John Baker wrote:
In real world would that translate, where "reports.mdb" is the
application and is in the
same directory as the original (calling) application, as:


Dim App As Access.Application
Set App = New Access.Application
App.OpenCurrentDatabase "Reports.mdb"
...
We can now use App.SomeAppMethod
or
App.SomeAppObject

This will depend upon what we want to do with/in the Reports.mdb.

Nov 13 '05 #5

P: n/a
REALLY?

Nov 13 '05 #6

P: n/a
lylefair wrote:
REALLY?


Yep.
Nov 13 '05 #7

P: n/a

Rick Brandt wrote:
lylefair wrote:
REALLY?


Yep.


Amazzing! Youse allways learning something knew hear.

Nov 13 '05 #8

P: n/a

"lylefair" <ly***********@aim.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Rick Brandt wrote:
lylefair wrote:
> REALLY?


Yep.


Amazzing! Youse allways learning something knew hear.


Actually you is always learning something you knew here.

Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.