Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

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?
0
etjordan
Asked:
etjordan
  • 3
1 Solution
 
nico5038Commented:
Try to use the .snp format.
Check:
http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm

It will give all report info...

Nic;o)
0
 
etjordanAuthor Commented:
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?
0
 
nico5038Commented:
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)
0
 
nico5038Commented:

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)
0
 
ComTechCommented:
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
Administrator @ EE
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now