Another database in a form

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

Malcolm

Hi,

Should there be any reason why one database can't be shown
in a form of another database?

In otherwords, within db1.mdb have a form that shows
db2.mdb.

I have a couple of related databases and just trying to
make it a little more convenient for users.

Being self taught, sample code would be a bonus!!


Thanks in advance


Malcolm
 
Hi,

Should there be any reason why one database can't be shown
in a form of another database?
In otherwords, within db1.mdb have a form that shows
db2.mdb.
Click to expand...

Yes, there is a good reason.

A Database is a CONTAINER for possibly hundreds of Tables, Forms,
Reports, Modules, Macros, and Queries. You can't "show" a database in
a Form or anywhere else - it's a composite object.

You can use File... Get External Data... Link to link to tables in
db2.mdb, and use those linked tables as the Recordsource for a form;
you can create queries joining a local table in db1 to a linked table
from db2; a number of other possibilities.
I have a couple of related databases and just trying to
make it a little more convenient for users.
Click to expand...

You'll need to be a little clearer about what from db2 you want to see
on this form!
 
Thanks for the reply John.

I just want my db1.mdb to control the opening then closing
of db2.mdb in a form, nothing else. I don't want to
access, link or control anything in it at all. When they
have finished work in db2.mdb, they just close the form
and are still in db1.mdb.

I could start it externally (As a seperate mdb running),
but need to get control back to my db1 afterwards.


Thanks again - your thoughts are appreciated.

Malcolm
 
I just want my db1.mdb to control the opening then closing
of db2.mdb in a form, nothing else. I don't want to
access, link or control anything in it at all. When they
have finished work in db2.mdb, they just close the form
and are still in db1.mdb.
Click to expand...

You cannot "open a .mdb file in a form", at least not to my knowledge.
I could start it externally (As a seperate mdb running),
but need to get control back to my db1 afterwards.
Click to expand...

I'm not sure how you can do this - you might want to repost with a
subject line "launching one .mdb file from another", I expect it can
be done but I don't know how! Sorry!
 
Thanks for your help John.

Regards

Malcolm

-----Original Message-----


You cannot "open a .mdb file in a form", at least not to my knowledge.


I'm not sure how you can do this - you might want to repost with a
subject line "launching one .mdb file from another", I expect it can
be done but I don't know how! Sorry!



.
Click to expand...
 
Back
Top