How do I copy from one form to another form in a different databas

[Guest]

I have around 10 different databases that people make calls from.
Consoladating them is not an option. I need a button on a form in each
database to copy a customers details, name, address, postcode to another
database. The other database will run in the corner of the screen and has the
fields txtname, txtaddress1, txtaddress2 etc to hold the information.

How can I, in VB, set focus to another database window and copy text from
fields in one to fields in another?

If I can copy the data directly into the other databases table that would
also work, or if each time you click the button it updates and adds onto the
bottom of an excel document, but the first solution seems the easiest.

Thanks in advance for your help

 

[strive4peace]

Hi Adam,

Firstly, you would be copying records from one TABLE to another... forms
are just a convenient way to show/edit data stored in tables...

if you want o APPEND records to another database, you can use this basic
SQL...

BASIC SQL SYNTAX

SELECT fieldlist
FROM tablename
IN anotherdatabase.mdb
WHERE conditions
GROUP BY fieldlist
HAVING conditions for fields that are grouped
ORDER BY fieldlist;

If you don't know what to do with this, post back and we can help you more


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*