I am very much a noob here so please talk slowly for me.
I have a database named Students. In it is a field named StudentID and another named StudentPhoto. StudentPhoto is a calculated field that pulls in the StudentID and inserts it into a local URL like this- "C:\Users\...\...\SCHOOL\Pictures\students28540.jp g" Specifically the calculated field has this expression in it:
"C:\Users\...\...\SCHOOL\Pictures\students" & [studentstudentNumber] & ".jpg"
I have all of the student photos in that same folder and the lookup field is working correctly, showing me the correct path to each image file.
My question is how the heck do I get their images to display in a report I have created? I have made a bound image on the report and attempted to connect it to the Students.StudentPhoto field but all it does is display an empty box.
I've tried a few scripted methods for doing this that I found on searches but I can't seem to get it to work. The one that came closest I thought was this one: http://www.databasedev.co.uk/bound_image_report.html but the script always gave an error that it couldn't find the table field.
Anyone have an easy, direct way to do this?
Sincerely,
MaestroC