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
--
Adam Thwaites
Access Database Designer
(E-Mail Removed)
Manchester, UK