Viewing Pictures

[orbic1]

I'm having difficulty in viewing pictures in a subreport. The related table lists 5 pictures:
photo1 -> photo5

Their fields hold the link to their location.
Here is a previous post with more information if necessary:
http://www.access-programmers.co.uk/forums/showthread.php?p=267539#post267539

Many thanks

 

[spacepro]

Hi Orbic,

Try this:

Picture in Report Sample DB

Andy

 

[orbic1]

Cheers, Andy! This works great! I converted it to accomodate 5 images.
However, I now get the following error: "You entered a null value" when I don't have no image. Is there a way around it in the code?

I suppose I could set the table's default value to "null.jpg" and auto update it is there is a null value, but there must be an easier way than that!

Cheers,

Ed

 

[orbic1]

One spelling mistake correction later and it all works!
Thanks!

 

[spacepro]

Glad you got it sorted.

Andy