Issue Cmds to Different DB

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

Guest

I'm still trying to figure out how check to see if another db has a form open
and if not then have THAT db open a form within itself. I've tried the
reference routine but when I executed the function in the other db to open
the form it opened the form in the current db and then tried to find the
tables in the current db.


Any other ideas?
 
Hi John, i tried it again and it worked

1. Create MDB1 with function that open a form, Form1
2. Create MDB2, with reference to MDB1 and run the function I created in
stage 1, and it opened the form
3.I also created a form in MDB2 with the same name, and it still opened the
form from MDB1.

There are some functions that is you run on MDB1, it will search for the
tables in MDB2 such as DLookUp, DSum etc
But for your case, I tried it and it works, just make sure that you don't
have a function in MDB2 with the same name of the function in MDB1, that can
cause your error, becuse Access will give the priority of functions to MDB2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
Access how to open existing database from another database using Access - VBA 0
Copying Form from one Access db to another. 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Events as the DB closes 4
Allforms Collection in another db (A2007) 4
Execute Procedure on a remote Access Db file 17
Linked Table DB Won't Open if BE DB is Moved 4

Back
Top