adding photos to a report 2

[gojohnnygogogogo]

hello,
how can I add a picture to my report, that changes per record. ?

eg. ID cards,
1234 - ID,
jo bloggs - name ,
1234.jpg - picture

all my pictures are stored in a folder like C:\photos
and all photos are the ID number . jpg.

any ideas ?
thanks.

 

[nberryman]

Do you want a database that does just that? If so e mail me with photo database in the subject and I will send it to you

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[gojohnnygogogogo]

cheers neil.

I have worked out what to do , but the quality of the images are sometimes terrible, also if a photo doesn't exsit for somebody it will crash.

How can I put an if statement to say if there isn't a picture leave blank, otherwise run the following code :

Me!Photo.Picture = "c:\photo\" & [STUD_ID] & ".bmp"


?

any ideas ?
thanks

 

[buee04]

hey gojohnny,

I'm also trying to put pics on my report for each record, can you help me out?

There's probably a better way, but you can have a default picture for those records that don't have pics so you don't have to do any coding.

 

[scriverb]

I answered a similar question with specific code in the following link:

Thread702-289543

This explaination was for a report but I also added a form object explaination at the bottom.

Hope this helps you.

Bob Scriver Bob Scriver

 

[buee04]

GREAT! That was easy bob! I thank you for your help!