Linking to thousands of external images

[taichi56]

I saw some great code for linking to external images but cannot seem to get it right. I have a database that will have 23,106 rows of data and I have to link to 23,106 .jpg that are loctated on C:\Photos.



In the table I made a field called: Photos, Dataset: Text
Then on the form I put an image box and in the control source I put =C:\Photos\"& [Photos]

The relationship I made a duplicate of my table and linked ID to Photos. Each card has a unique ID number. But I am not getting nay pictures to link. I uploaded an example of the database.

[June7]

You are using a BoundObjectFrame control. Try using the Image control instead.

[taichi56]

Ok, I tried using the image control and it wants me to put an image in the frame. When I do it is the image that is used for all 23,106 records. So I did not put a graphic but then nothing comes up. In the control source I put: ="C:\Photos\" & [Photos]

[June7]

Need to include the Photos field in the form's RecordSource. I use the Image control for dynamic display of external images. I have never used OLEObject controls.

Rats, your form is not cooperating. Okay, finally got images to display.

[taichi56]

Ok, I found how to add the the Photos field in the form's RecordSource. I did not get any images to show that way. But what I did was go to my table and type in the url in the field of "Photos", I put this: C:\Photos\189642.jpg and on the next one I put the id of that one also. I then went to the form and in the control source I picked "Photos" It showed me both of my pictures. But I cannot type in every url with the id number for 23,104 .jpg pics left. I will be there forever. How do I do it automatically? What am I missing? Thank for your help.

[June7]

If the record ID number is the same as the name given to the corresponding jpg the Photos field is not needed. Try this expression in the ControlSource:

= "C:\Photos\" & [ID] & ".jpg"

Why do you have quote mark preceding values in the name field?