Electronic Importing

[Tony]

Does anyone know if you can import a form from another
database and then check it against the database you are
importing to, to see if the record already exist. And
also how would you go about doing this by a button?

 

[Nick Coe \(UK\)]

Tony,

You can import an Access form from one database into
another, but forms do NOT contain data.

Forms are essentially ways to view and edit data in
underlying tables. When you import a form from another
database you really only import it's design.

I suspect you want to compare the actual data in two
different databases, in which case you need to establish the
names of the tables or queries which feed the forms you're
interested in. Then link the appropriate tables from one
database to another and write a query to compare those
tables.

Yes it can be automated with vba and whilst it isn't
complicated it could grow arms and legs like mad.

Do you wish to go further?

 

[Guest]

-----Original Message-----
Tony,

You can import an Access form from one database into
another, but forms do NOT contain data.

Forms are essentially ways to view and edit data in
underlying tables. When you import a form from another
database you really only import it's design.

I suspect you want to compare the actual data in two
different databases, in which case you need to establish the
names of the tables or queries which feed the forms you're
interested in. Then link the appropriate tables from one
database to another and write a query to compare those
tables.

Yes it can be automated with vba and whilst it isn't
complicated it could grow arms and legs like mad.

Do you wish to go further?

 

[Guest]

Yes, I would like to know how to do this. Thanks

-----Original Message-----
Tony,

You can import an Access form from one database into
another, but forms do NOT contain data.

Forms are essentially ways to view and edit data in
underlying tables. When you import a form from another
database you really only import it's design.

I suspect you want to compare the actual data in two
different databases, in which case you need to establish the
names of the tables or queries which feed the forms you're
interested in. Then link the appropriate tables from one
database to another and write a query to compare those
tables.

Yes it can be automated with vba and whilst it isn't
complicated it could grow arms and legs like mad.

Do you wish to go further?

--
Nick Coe (UK)
www.alphacos.co.uk

---




.