Linked Images in MS Access Reports 1

[TheFitz]

Hi all,

I'm struggling to get an image into a report that is different for each record.

The situation is as follows:

I'm designing an ID type system. This will generate ID passes as an output. These ID passes will have a picture of the user on it. The Filename of the picture is stored in field 'PEO_FILENAME' in table 'People'.

I am using the following code to place the image on the form, however, I can't seem to do anything similar in a report. Any ideas??

Me.imgPicture.Picture = rstPeople![PEO_FILENAME]

I'm really struggling, have I attempted this the wrong way?

If it helps, I'm using MS Access 2003 to do this.

Many thanks for your help,

Regards, TheFitz

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!

 

[ProgramError]

Im assuming you are wanting to print off ID cards with and thats the reason for the report. How about printing the form instead of the report.


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[ProgramError]

this may also help

http://support.microsoft.com/default.aspx?scid=kb;en-us;285820

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[TheFitz]

Thanks Ian,

Got it, your post put me on the right track and then I noticed the the OnFormat event and combination of your secnd suggestion got it working.

Many thanks.

Fitz

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!