Using images stored in local folder in report

[robthedog]

Hi All;

Any advice would be much appreciated….

I have a db of products which drives an ASP website, and includes links to images, which I have now stored locally (with the image path amended to point to the local images folder) along with the images folder containing all the images.

What I now need to do, is produce Access reports using these images, this I initially assumed would be a simple task, but hasn’t in practice worked out that simple!!

So, I now have local folder containing the images, and the products table with an Image field that stores the local path to the image – How can I now get the record and corresponding image to appear in my report? I’ve tried using an OLE field for the images, but this means updating each record manually (unless there is any way of updating the OLE field from the existing image path field??)

Am I missing something totally obvious here?

Thanks in anticipation!

 

[Mile-O]

I would just have stored the links as basic text and used (X)HTML to create an image tag on the Active Server Page to display the image. Of course, Access online isn't something I've ever tried.

 

[robthedog]

Ah! Maybe I didn't make the question clear... What I need to do is produce hard copies from Access Reports. The web version isn't a problem.

Cheers

Rob