PC Review


Reply
Thread Tools Rate Thread

How do I copy data from a form to a form in another database

 
 
=?Utf-8?B?QWRhbSBUaHdhaXRlcw==?=
Guest
Posts: n/a
 
      6th Oct 2006
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy data from a form to a form in another database =?Utf-8?B?QWRhbSBUaHdhaXRlcw==?= Microsoft Access 0 6th Oct 2006 05:08 PM
Switchboard usage preventing my form loading data form my database =?Utf-8?B?RWFtb25u?= Microsoft Access Getting Started 4 7th Sep 2006 09:46 PM
Copy data from form to form using VB Paul Microsoft Access Forms 2 6th Jan 2004 12:24 AM
How do I copy data from one form over to another form so I don't have to fill out the information twice? Ryan C. Microsoft Access Forms 0 28th Dec 2003 11:07 PM
Re: Copy data from sub form into form John Vinson Microsoft Access Form Coding 1 19th Aug 2003 10:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:35 AM.