Solved

OLE Object Export

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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now