Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Unable to output contents of a report to Word
- Thread starter mitchec
- Start date
a graph will only output as SNAPSHOT format. snapshot viewer is a free utility provided by microsoft, search Snapshot Viewer on you can download it, and so can everyone else.
- Thread starter
- #3
a chart cannot be put into any other type of document. it's not really a chart that you're seeing, it's just a visual thing. if you really need it in word, the best i can offer is to get the data from access, copy it to excel, then embed the excel chart object into Word. sounds like a lot of work...
I saw this on a news group. Perhaps it is what you are seeking?
<Greg.Pigott@PSS.boeing.com> wrote:
> I am having a problem when I try to export (send to) a report that contains
>a graph OLE object. When I export it, all I get are the text portions of my
>report in my RTF file. I've tried using OLE automation from Word to access
>the report, but haven't had any success. I need to be able to export this
>report and embed it into a Word document for printing. Can anyone help?
>
>
I had a similar problem. The way I resolved it was to export the data
to an Excel file using OLE, then re-create the chart using Excel.
Then you can embed this into Word if you like. If you set up a
template Excel spreadsheet with the chart drawn for some sample data,
you can then just plug in new numbers into the spreadsheet straight
from Access, which will re-draw the chart.
Terry.
<Greg.Pigott@PSS.boeing.com> wrote:
> I am having a problem when I try to export (send to) a report that contains
>a graph OLE object. When I export it, all I get are the text portions of my
>report in my RTF file. I've tried using OLE automation from Word to access
>the report, but haven't had any success. I need to be able to export this
>report and embed it into a Word document for printing. Can anyone help?
>
>
I had a similar problem. The way I resolved it was to export the data
to an Excel file using OLE, then re-create the chart using Excel.
Then you can embed this into Word if you like. If you set up a
template Excel spreadsheet with the chart drawn for some sample data,
you can then just plug in new numbers into the spreadsheet straight
from Access, which will re-draw the chart.
Terry.
Take a peak at this thread...there is a link to a site with code that may help you out.
- Status
Similar threads
- Locked
- Question
