| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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 -- Adam Thwaites Access Database Designer (E-Mail Removed) Manchester, UK |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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 * Adam Thwaites wrote: > 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 > > |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how do I attach a prexisting databas to a form as a default? | =?Utf-8?B?dHNhbQ==?= | Microsoft Word Document Management | 0 | 8th Jun 2006 07:47 PM |
| how do I attach a prexisting databas to a form as a default? | =?Utf-8?B?dHNhbQ==?= | Microsoft Word Document Management | 0 | 8th Jun 2006 07:47 PM |
| Using a Worksheet Form to add data to a separate worksheet databas | =?Utf-8?B?UmF3Ymx5bg==?= | Microsoft Excel Worksheet Functions | 3 | 7th Mar 2006 08:17 PM |
| Can data be collected using an Outlook form for an Access Databas. | =?Utf-8?B?QXVkaXQ3Mw==?= | Microsoft Access External Data | 0 | 11th Jul 2005 06:52 PM |
| Query - how to get the blank form to show, not search the databas. | =?Utf-8?B?RHJfUmljaGll?= | Microsoft Access Queries | 1 | 29th Nov 2004 07:06 PM |
