How Do you open a form in a separate Access database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two database one an archive the other "Database2" is used to run a
reports from subsets of data. When I update the data using a form in the
Archive I then need the code that would send me over to database2 AND open a
form there. Can Anyone Help????
 
Why are you storing it in a separate database if you have to use it often?
Just mark old records with an "inactive" checkbox.

That issue aside, another solution would be to have all these forms in ONE
database (a front-end) and link to the tables in your two back-ends.
 
You can use reference from MDB1 to MDB2, so MDB1 will recognise all the
functions in MDB2.
Open MDB1, when you are in code (any where), select tools, reference. browse
and select MDB2.
You will notice that MDB1 recognise all the functions, but it wont recognise
forms, reports, macros etc, so if for example you want to open a form in MDB2
From MDB1, create a function in MDB2 that open the form, and then call that
function from MDB1, the same about queries, mdb1 wont recognise queries on
mdb2, but you can create a function in mdb2 that run the query, and you can
call this function from mdb1.
 
Back
Top