Adding JPEGs to a report

[Lisa S]

Hi

I have also posted this to the tables forum as I was not sure where it fitted in.

I am trying to create reports based on the following:

I have, with previous help from this forum, created a table which details approx 200 images but holds the path only and the images themselves are in a different folder outside of Access as holding the images in a table made the db size HUGE.

I have created a query to gather the fields which I need, including the image path.

I then need to create a report to look at the image path, lookup the image and display the actual image in the report. I have found out how to do this in a form with Alexandres help (thanks) but cannot find any help as to how to do this in a report.

Thanks in advance for any help

 

[Alexandre]

I am going to email you a sample DB that should give you a start. Obviously, it is still very rough and needs many improvements, namely proper error handling and redirection to a find dialog when the images are not found.
Note that it uses a reference to the VB extensibility 5.3 in order to use the common Dialog Control.

Alex