I have a working form that displays each student's details and their photograph - in that when I choose a student, their photograph is displayed along with their details

I need to create a report that shows all student's - their names and their photographs.

Any ideas??

Gerry

Hi Gerry,

I'm no expert but I think all you need to is create a report using the wizard and tell it to base the report on your table. Select the fields you want including the pictures and just go with all the default options to begin with.

Never worked with pictures myself but I understand the data in your table might be a hyperlink to the location of the picture on your computer (or network/server/website/whatever)

Provided you run the report in an environment where you have access to these pictures, it should work.

I think!

Hey Big Pat,

I had already tried the report wizard - it uses a text box for the image -
have tried replacing the text box with an image frame pointing to the location of the photgraphs - \\server\Users\Database\Students\Photos\E0000430.j pg -
Now I can see one photograph but its the same photgraph for all the students?? hmmm???

Hey Big Pat,

I had already tried the report wizard - it uses a text box for the image -
have tried replacing the text box with an image frame pointing to the location of the photgraphs - \\server\Users\Database\Students\Photos\E0000430.j pg -
Now I can see one photograph but its the same photgraph for all the students?? hmmm???

Gerry,

E0000430.jpg sounds like the photograph of one particular student, so that is why you are getting that picture all the way down your report. Something in the DETAIL section of your report needs to refer to the individual photo. There must be a field in your database which refers to this.

Open the table containing the students details and scroll along it. There will probably be fields for surname, forename, study course, etc. Somewhere along there will be details of their picture. It might just be a long field containing numbers which the database will know how to convert back to a picture. Or it might be a field containing hyperlinks to where photos are stored on your computer or network.

Either way, the crucial thing is that it's different for every student. THAT's the field you need to bring into the detail section of your report.

If you still have no success, you should probably post a new question on here. This is as much as I know, to be honest!

Pat