Image Lost in Export To Word

[GeoNelix]

Hello All (and happy March Madness - GO ILLINI!!!)
I am exporting an access report as a word document and the exported file loses an image that the report contains. Is there an easy way to ensure that the image is not lost? The process generates an rtf file and the rtf version of the report looks bad without the image. Thanks in advance!

 

[The_Doc_Man]

This is a fact of life with Access. Exporting a document goes through .RTF format because Access isn't a word-processing package.

The correct way to do this is either:

1. Build the document as a template and mail-merge the contents. This only makes sense if the image is a constant such as a dimmed-out watermark type of thing.

2. Write code with VBA to open Word as an application. Again, include the document you want as a specialized template. Then insert your text. There is also a way to insert images if the image in question is not a constant.

The general rule is, if you want it to look like the best document Word can offer, you have to build it in Word in the first place.

 

[GeoNelix]

Yeah...

I was hoping to avoid those solutions, but that's what I figured had to be done. Nothing's easy with Access eh? Thanks Doc!

 

[The_Doc_Man]

No, nothing GOOD is easy in Office. But to the good, you at least can get to the stuff you need to get it. Now, finding where they put it might be tricky...

But trust me on this. When I first converted to Access (2.0), it was because my other PC-based database package converted to Windows and when they did, they ... to put it gently... screwed the pooch.

Access has one big benefit - you can get to nearly everything, so you can do nearly anything. Access has one big drawback - you can get to nearly everything, which gives you too many choices sometimes.

Good luck!