Open Access Form in Another Access Application

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

Guest

Hi,


Purpose:
I have couple of form in different databases I need to make a menu to
operate those forms.

Question:
Is there any way to link and Run Ms Access forms in other Ms Access database
(Just need to run don't want to change any functionality of form) as we do
Tables?

Any Thoughts?

Thanks for help in advance:)

AA
 
Say Database A is the database you want to be running and the form you want
to open is in Database B ---

In Database A, You could link to the tables in Database B you need for the
recordsource of the form and then create a copy of the form in Database A.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
The way I do it, I have MDB1 and MDB2, I create a reference to MDB2 from MDB1
(in code view select Tools > Reference > add MDB2).

At that point MDB1 will recognize all functions in MDB2, but only function
in the modules, it wont recognize the rest of the objects in MDB2.

Create a function in MDB2 that open the form

You can run the function created in MDB2 from MDB1, and the form will open,
and it will look like the form is placed in MDB1 it wont open another Access
application.
 
Thanks for the reply,

Let me try with your suggestion and I will get back to you.

But FYI - Please see below my problem in detail.

Db1 = Where I want to creat menu

DB2 (Creating Report using SQL 2005 & Access)= In Db2 using some pass
through queries (Accessing SQL 2005) and created few tables within DB2. There
is only one form in DB2 (on the click of button all queries execute at server
end and at local Access end) and create report using Access.

Thanks again for your time and help .

AA
 
Steve said:
Say Database A is the database you want to be running and the form you want
to open is in Database B ---

In Database A, You could link to the tables in Database B you need for the
recordsource of the form and then create a copy of the form in Database A.
Click to expand...

<sarcasm>
Hi Steve, welcome back again.
</sarcasm>

I noticed that a lot of people in the newsgroups are *not* very fond of you...
This is only because we just don't like your advertising here.

So you took a deep breath for a couple of days ?? Good !
We hope you also have done some thinking ...

FYI:
The link to the website draw a *lot* of attention the past few days.
76 unique visitors and 130 pageloads !!

Arno R
 
Back
Top