Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

OLE Object Export

Posted on 2002-07-18
5
Medium Priority
?
620 Views
Last Modified: 2013-11-28
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
Comment
Question by:etjordan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 54

Expert Comment

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

It will give all report info...

Nic;o)
0
 

Author Comment

by:etjordan
ID: 7163584
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
 
LVL 54

Expert Comment

by:nico5038
ID: 7163612
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
 
LVL 54

Expert Comment

by:nico5038
ID: 7281497

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
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 7315392
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
Administrator @ EE
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question