Adding photos to a form

[neil27]

I have created a profiling database for my school. Each student can access their own form via the school's admission number - which I use as the primary key for most of the tables on the form. One section of the form shows a photo of the student. I take this photo from the school's SIMS photo file which had all the children's photos. Each photo in the file uses the school's admission number as its filename (for example 000358.jpg ).

I want to update the photos in my table by using a macro or piece of CBA code. Unfortunately, I don't know how to do this. When I set the database up I did each photo one at a time, so it took several hours. Does anyone know how to do this another way?

Thanks

 

[Catalina]

Double post.

 

[neil27]

Sorry Catalina - I wasn't sure which area to use so I put my question into several.

 

[Vassago]

If you're unsure, post it in the General section only. There's no need for multiple threads. Please don't do it again.

 

[neil27]

Can anyone help with the problem? I am using Access 2003 and the photos are .jpg so currently I have to change each one manually to .bmp and then resize to fit the space in the form. Does anyone know how to do this a better way?

 

[neil27]

I have tried doing a search for similar posts but haven't found one where a solution has been offered - just several people with a similar problem.