If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to copy OLE fields between two tables
Hi folks,
I have an Access database containing two tables. The first table (tblSource) contains an OLE field in which Word documents are embedded. The second table (tblDestination) is similar to the first one, as it contains also an OLE field for Word documents. I created a form based on the table tblDestination. From this form, I want to be able to select a record from the table tblSource, and copy the OLE content of that record in the current OLE field on my form i.e. in the current OLE field of the current record of the table tblDestination. The record to be copied would be selected using a drop list control (showing a text field in tblSource), and the copying action would be triggered by a button click. Thank you very much in advance, Marc Melillo |
#2
|
|||
|
|||
How to copy OLE fields between two tables
Just copy the field's contents directly from the source to the destination
field. Post the code you've got so far and someone will be able to help you work through it. -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "marcm" wrote in message oups.com... Hi folks, I have an Access database containing two tables. The first table (tblSource) contains an OLE field in which Word documents are embedded. The second table (tblDestination) is similar to the first one, as it contains also an OLE field for Word documents. I created a form based on the table tblDestination. From this form, I want to be able to select a record from the table tblSource, and copy the OLE content of that record in the current OLE field on my form i.e. in the current OLE field of the current record of the table tblDestination. The record to be copied would be selected using a drop list control (showing a text field in tblSource), and the copying action would be triggered by a button click. Thank you very much in advance, Marc Melillo |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy and Paste a Group of Fields | News Groups | General Discussion | 1 | September 21st, 2005 05:34 AM |
Unable to link two tables in access having identical fields | sathish_sns | Running & Setting Up Queries | 19 | May 18th, 2005 03:41 AM |
Many-to-many implementation problem | Al Williams | Database Design | 15 | April 29th, 2005 05:19 PM |
Copy Multiple Tables with Relationships | dang nguyen via AccessMonster.com | Running & Setting Up Queries | 3 | December 7th, 2004 01:22 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |