Open Access Form in Another Access Application

P

Prince

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
 
S

Steve

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
[email protected]
 
O

Ofer Cohen

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.
 
P

Prince

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
 
Top