Is there anyway to create a MS Access form and share it?

C

CatherineDiane

I would like to create a form at home and then get it to the office for use.
Is there anyway, tricky or otherwise, to use a form which was not created on
the pc it will be used on?

The database has changed since I emailed myself the database to use,
although it is the same database, it just has new entries...

Thanks! Catherine
 
D

Dirk Goldgar

CatherineDiane said:
I would like to create a form at home and then get it to the office for
use.
Is there anyway, tricky or otherwise, to use a form which was not created
on
the pc it will be used on?

The database has changed since I emailed myself the database to use,
although it is the same database, it just has new entries...
Click to expand...


I'm not entirely sure what it is you want to do. You can import a form from
one database to another, so if you bring a copy of your "home" database to
the office, you can import the form from that copy into the office database.
Of course, if the form is based on a table that is not in the office
database, or if the home version of the table has different fields from the
office version, then you may need to do some table design work at the
office.

Bear in mind that using the same form in the office database as you use at
home doesn't mean that the *data* will be shared between the databases. If
sharing data is what you have in mind, that's a much more complicated
matter.
 
J

John W. Vinson

I would like to create a form at home and then get it to the office for use.
Is there anyway, tricky or otherwise, to use a form which was not created on
the pc it will be used on?

The database has changed since I emailed myself the database to use,
although it is the same database, it just has new entries...

Thanks! Catherine
Click to expand...

An Access Form exists *only* within the confines of an Access database, and
requires the msaccess.exe application program to use it. It has no independent
existance outside the database. You can bring your .mdb file from home and use
File... Get External Data... Import to import it into another database, but
each user who'll be using it will need access to the mdb file and to the
Access program.

John W. Vinson [MVP]
 
L

Linq Adams via AccessMonster.com

Sure!

Change the name of your home copy of the database. It'll make it easier to
keep the two versions of the db straight when you get to work!

When you get to work ***make a backup copy of the work db***

Copy your home version of the db to your work PC

Open the work db. If the form you made at home is to replace a form of the
same name in the work db, deleter it..

Goto File - Get External Data - Import

Select the home version db and import the new form

That should do it!
 
C

CatherineDiane

Wonderful! I think this will work perfectly.

It is the same database I emailed myself from work. I created the form I
wanted, but it was several weeks before I did it. Then I realized that I
can't just "attach" my form and email it back. Talk about a *deep sigh*. Then
I thought there HAS to be a way to get this form back to the office!

Thanks again!
 
Top