Reference another Database

[AmyLynnHill]

Greetings,
I have a database and need to put a button/combo box/???? that will reference another database and reference a form within that DB. I also need it to filter to a certain record on the form(Group field).

I was playing around with the RunApp in a macro but dont know what I'm doing.

Any ideas, examples, suggestion on how to approach this?

 

[Mr. B]

I am not sure that I understand just how or why you expect to reference another form in another database if that database is not open. If you are simply talking about a value from a field then that can be done. I have a feeling that you are talking more about the data than the form.

By using linked tables, you can work with the data from just about any other database, provided you can connect to it. It is possible to link to tables in multiple databases at the same time.

HTH

 

[AmyLynnHill]

I'm trying to avoid linking the tables, importing the forms/querries/reports in the other database.
Trying to find a way to reference it.

 

[Mr. B]

If you don't mind, why are you trying to avoid linking?

 

[AmyLynnHill]

The form I'm referencing has 5 buttons that refereence other forms built off of querries and tables. Also reports are attached.

I would need to link 5 tables, import 7 forms, 3 querries and 2 reports.

Its a matter of do I really want to do that or merge the two together?

a reference would save alot of effort. This database is only going to be in production for another 6-8 months so minimal effort is my approach.

 

[Mr. B]

Well, as far as I know, there is no way to just reference a form unless that form is open.

I suspose that my best suggestion would be to import the objects from the other database into the new one. That would be the simplest and quickest method.

Thanks for the explanation. I was just curious.

 

[AmyLynnHill]

The form will be opened.

 

[Mr. B]

With that in mind, let me look at this. Sounds interesting.

 

[Mr. B]

The only thing that I found at all concerning referencing another database indicated that you could set a reference to that other database and then use it's objects through VBA code. I tried it a little but I did not see anyway to refer to one of it's forms, etc. Perhaps someone else may have more info on this one.

Sorry I was not more help, but I will keep an eye on this discussion. I would like to see if anyone else has any other ideas.

 

[AmyLynnHill]

I appeciate your efforts!

Most likely i will be linking. If I find an alternative I'll post it! Have a great Day!