Image On A Form

[WKRJ]

I have been tasked to scan family pictures in such a way so they are available to older family members to identify people younger family members don’t know. My solution is to scan each photo, name them 1.jpg, 2.jpg…. about 4000 images. Store them in a directory (H:Family). I then want to create a form that will use the PK which is an auto number to pull that numbered picture into the form where someone can enter the other fields. I have fun with Access but this is well above my knowledge level!!
Thank you for any help!!
WKRJ

 

[CJ_London]

1. Create a text field in your table which is the filename of your jpg
2. populate the field with all your filenames
3. in your form have an unbound image control and set its control source to the filepath and the name of your filename field - something like

="H:\Family\" & myfieldname & ".jpg"

 

[WKRJ]

Thank you for the response. That's how I'm thinking. I have a directory with 3 images in it, 1.jpg, 2.jpg and 3.jpg. I have a table with an auto number named 'PhotoId' as the PK and a text field named 'Image'. On my form, I have an image box with the control source set to 'Image'. In the table the Image field for the records are '=H:\AllPhotos\&[me].[PhotoId].[value]&".jpg".

Thank You!
WKRJ

 

[CJ_London]

glad you got it working - note ther is no need for the.[value], it is the default

 

[WKRJ]

Hi again. that's just it, it does not work. I have read and looked and read and I don't see what I'm doing wrong. If you would, could you take another look

Thank You Again
WKRJ

 

[CJ_London]

What you should have as your image control source is

="H:\AllPhotos\" & [PhotoId] & ".jpg"

Note the correct use of the quotation marks

In your [PhotoId] text control I would expect you just to have the name of the file

 

[WKRJ]

Thank You! your code is perfect! Talking about attention to detail, one misplaced " = trouble. Thanks Again

 

[joinnguyen]

thanks for shared