Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 207751 - Last Review: June 30, 2004 - Revision: 2.0
ACC2000: OLE Objects Do Not Appear in Output File
This article was previously published under Q207751
For a Microsoft Access 2002 version of this article, see
288152Â
(http://kbalertz.com/Feedback.aspx?kbNumber=288152/EN-US/
)
.
Novice: Requires knowledge of the user interface on single-user computers.
If you output a report from Microsoft Access to another file format, such
as .rtf, .txt, .xls, or .html, an OLE object that has been inserted into
the report does not appear.
Although some output file formats, such as .rtf or .xls, do support embedded or linked OLE objects, Microsoft Access does not support outputting an OLE object to another file format.
If the OLE object has been saved separately, you can first output the
report, and then insert the OLE object into the resulting file.
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- In the Database window, click Reports under Objects, and then click New.
- In the New Report dialog box, click AutoReport: Tabular. In the Choose the table or query where the object's data comes from list, select the Shippers table, and click OK. The report opens in preview mode.
- On the View menu, click Design View, and select the detail section of the report.
- On the Insert menu, click Object, and in the Insert Object dialog box, select Microsoft Clip Gallery. Click OK.
- Click the Pictures tab, scroll down and click Transportation, click the Air Travel picture, and click OK.
- On the View menu, click Print Preview. The picture appears in the detail section of the report.
- On the Tools menu, point to OfficeLinks, and then click Publish It With MS Word. If the Convert File dialog box appears, select Rich Text Format (RTF), and click OK. Note that the report opens in Microsoft Word, but that the OLE object does not appear.
For more information about outputting data, click
Microsoft Access Help on the
Help menu, type
OutputTo Action in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate