asked on

OLE Object Export

I have inserted a file (a MS Word signature block, 5 lines)into an Access table field as an OLE object. From the table, I produce an MS Access report with other regular type data and the bound OLE object. The report is complete and displays the object in MS Access, but when I export the report in Rich Text format, the exported report is not complete - The OLE object did not survive the export. What can I do to export the complete report from Access so that the OLE object is also exported?

nico5038

Try to use the .snp format.
Check:
http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm

It will give all report info...

Nic;o)

etjordan

ASKER

nico538,

Thanks, I had forgotten to mention that the receiver of my exported document needs to edit the report/document after I export it (edit is only for the non OLE object data). I had tried snapshot format, and the object is right on the export, but it appears that the document is no longer editable. Is there a solution that allows edit?

nico5038

Not "straight away" that I know of, but why use in this case a report?
You could use automation or MS Word mailmerge to create the document.

Idea ?

Nic;o)

nico5038

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

ASKER CERTIFIED SOLUTION

ComTech

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial