Linked (path in table) word viewed in report. 1

[g685]

Hello,

I have a report which shows through an OLE object embedded word documents. My db has now bloated and am looking for a way to store the word documents outside the db, store their paths in a table but continue displaying them within the report (the report is a product label and I am using word to display nicely formatted, non-standard texts).

I have found info on how to create a button which opens word but I am looking for a way (through an OLE object?) to continue displaying the word document within the report, as it is part of a label to be printed. Is there a way (through VBA?) to tell the OLE object which document to display? Or any other way to continue displaying the word doc (stored outside the db) within the report?

 

[MajP]

What version of Access? 2007 and beyond has a lot more features to make this easier. It supports Rich Text which may provide enough formatting to allow you to do away with the word documents, and it supports attachment fields which do not bloat.

 

[g685]

Hi,

It is 2003. I suppose upgrading could be an option if nothing else comes up. The reason I would prefer to stick with word is because these texts are maintained by admin staff, not very advanced technically.

 

[MajP]

I do not think it can be done what you describe. I may be wrong, but I know of no easy way. If I need a lot of fancy formatting, I do it the other way. I build word templates and then write to them, or have the word template read from the database.