I have a db that has records with references to documents (primarily Visio, Word, and PowerPoint documents) stored on the external filesystem. I'm only storing the paths to these references - I'm not storing them as embedded or linked OLE fields.
This works well on my form, where I can store the paths to the documents and preview what the document looks like via an unbound object.
The problem is that I want to also include the images of these documents in a report (i.e., show the Visio picture on a page in the report). I tried adding the unbound object with a bit of code to update the SourceDoc (as I did for the form), but this doesn't seem to want to work. Microsoft provides some guidance for how to accomplish something similar for images (http://support.microsoft.com/kb/148463), but I can't seem to find support for making this work for other types of documents (Visio, Word, PowerPoint).
If I store the document links in an OLE field, I can get it to work, but would much rather be able to simply store the path and render the images as needed when printing the report. This seems like an obvious thing to want to do, but I cannot seem to make it work. Has anyone else solved this problem?
This works well on my form, where I can store the paths to the documents and preview what the document looks like via an unbound object.
The problem is that I want to also include the images of these documents in a report (i.e., show the Visio picture on a page in the report). I tried adding the unbound object with a bit of code to update the SourceDoc (as I did for the form), but this doesn't seem to want to work. Microsoft provides some guidance for how to accomplish something similar for images (http://support.microsoft.com/kb/148463), but I can't seem to find support for making this work for other types of documents (Visio, Word, PowerPoint).
If I store the document links in an OLE field, I can get it to work, but would much rather be able to simply store the path and render the images as needed when printing the report. This seems like an obvious thing to want to do, but I cannot seem to make it work. Has anyone else solved this problem?
