Solved

OLE Object Export

Posted on 2002-07-18
5
614 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

635 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