Opening a form from a form in a different DB

[jjarman]

Is there a way to open a form from a form in a different database? I'm pretty sure it needs to be done in VBA and have seen some code floating around that suggests it can be done, but I'm thinking there's more to it, like maybe one or both of the DB's need to be in a different format?

Thanks

 

[vbaInet]

What matters most is that the db you're running the code from is opened with a version of Access that can also open the db you're trying to open. So if you had Access 2003 installed and you're trying to open an Access 2007 db it won't work.

Yes there's lots of code floating around so please do an Advanced Search. If you're still unsuccessful, give us a shout.

 

[Pat Hartman]

What is the purpose of opening the form in the other database?

 

[speakers_86]

vbaInet, I don't see how that matters. If they were different, he could still shell it with a command line switch to pass the form name. I don't know if shell and switches can be used together, but if not, you could still write a batch file.

edit, unless he cannot modify the destination database, then you might be right sir.

edit, here's some code that might help our op. We like to help, but Google will answer your question far faster then we can.

 

[RainLover]

Why?
You could import the Form and link the required tables in a minute or two.
Job done.
Why are so many people insistent on doing things the hard way and why are so many advisors happy to promote such activities.

 

[speakers_86]

Maybe there is a reason he's doing this. I did it once. I made a button in the ribbon that opens Allen Brown's database checker, sets the value of a text box, and then quits the database. I did this in an open source project, and didn't want to take over Allen Brown's hard work or distribute something that does not belong to me. Plus, what if Allen Brown puts out an update?

 

[RainLover]

Maybe there is a reason he's doing this. I did it once.

I have done it more than once which means very little.

I believe in promoting the KISS principal first. Maybe the reason for the request is due to a lack of knowledge. Who knows.

I think Pat asked the right question.

 

[vbaInet]

vbaInet, I don't see how that matters. If they were different, he could still shell it with a command line switch to pass the form name. I don't know if shell and switches can be used together, but if not, you could still write a batch file.

How do you intend opening an accdb from Access 2003?

 

[vbaInet]

How do you intend opening an accdb from Access 2003?

Perhaps I should rephrase that, how do you open an accdb from Access 2003 without Access 2007 installed?

 

[speakers_86]

I guess you dont. I've been a little trigger happy in this thread.