Open Access Form in Another Access Application

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prince - 31 May 2007 15:12 GMT

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

Reply to this Message

Steve - 31 May 2007 16:48 GMT

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
resource@pcdatasheet.com

> Hi,
>
[quoted text clipped - 13 lines]
>
> AA

Reply to this Message

StopThisAdvertising - 31 May 2007 18:09 GMT

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

<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

Reply to this Message

Ofer Cohen - 31 May 2007 16:51 GMT

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.

Signature

Good Luck
BS"D

> Hi,
>
[quoted text clipped - 12 lines]
>
> AA

Reply to this Message

Prince - 31 May 2007 17:21 GMT

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

> 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).
[quoted text clipped - 24 lines]
> >
> > AA

Reply to this Message