Copying forms in database

[abprules]

Is there any way to copy only the forms from one .mdb file to another?

[pietlinden]

abprules wrote:

Is there any way to copy only the forms from one .mdb file to another?

just import them into the new db... what's the problem?

[fredg]

On 26 Sep 2006 10:15:13 -0700, abprules wrote:

Is there any way to copy only the forms from one .mdb file to another?

Open the database into which you wish to copy the forms.
Click on File + Get External data + Import
Navigate to the database that contains the forms you wish to copy.
Select those you wish to import. Click OK.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Bart]

Hi,

In my case the forms try to connect to a server that isn't online.
How do I get around that issue?

Thanks,
Bart

fredg schreef:

On 26 Sep 2006 10:15:13 -0700, abprules wrote:

Is there any way to copy only the forms from one .mdb file to another?

Open the database into which you wish to copy the forms.
Click on File + Get External data + Import
Navigate to the database that contains the forms you wish to copy.
Select those you wish to import. Click OK.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Rick Brandt]

Bart wrote:

Hi,

In my case the forms try to connect to a server that isn't online.
How do I get around that issue?

Change their RecordSource to something else? It's not clear what you want to
accomplish. Do you want to use the same form design in another context or what
exactly?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Bart]

Hi Rick,

Thanks for the reply!

I have an mdb file which is the "front end" (form design?) of an
Access application. The data itself is stored in a SqlServer. When I
open the front end, it tries to connect to the SqlServer, which isn't
online.

I've exported the data on the SqlServer to an mdb "data" file.
Opening the "data" file and "importing" the "front end" does not work
for tables (it works for reports, queries, etc).

While importing the tables of the "front end", Access tries to
contact the SqlServer. How do I explain Access that it should look for
a "data" mdb file?

Your comments are highly appreciated!

Thanks,
Bart

Rick Brandt wrote:

Bart wrote:

Hi,

In my case the forms try to connect to a server that isn't online.
How do I get around that issue?

Change their RecordSource to something else? It's not clear what you want to
accomplish. Do you want to use the same form design in another context or what
exactly?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Rick Brandt]

Bart wrote:

Hi Rick,

Thanks for the reply!

I have an mdb file which is the "front end" (form design?) of an
Access application. The data itself is stored in a SqlServer. When I
open the front end, it tries to connect to the SqlServer, which isn't
online.

I've exported the data on the SqlServer to an mdb "data" file.
Opening the "data" file and "importing" the "front end" does not work
for tables (it works for reports, queries, etc).

While importing the tables of the "front end", Access tries to
contact the SqlServer. How do I explain Access that it should look for
a "data" mdb file?

Your comments are highly appreciated!

Go the other way. Delete the links in your front end and then create new links
to your MDB back end. If the tables/links have the same name as beofer then it
will work.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com