Linking picture files to an Access database

lot of effort for a single photo

I need to do just this, but you didn't tell what I need to know. I need to make a relative path to the photos in the folder, so that the access file + image folder can be moved to other computers. Unfortunately you only showed it with the absolute path. How do you make a relative path?

Good Lord! Thank you so much for this! I was going crazy looking at all these other tutorials that WERE NOT WORKING!!! 🤪

doing this for 10,000 employees would take a life time

it did not work :(

Thank you, it was very helpful, solved my problem!

How can I add multiple pictures to one line item? like receipts particular to one merchant?

thank u so much it helped me 👍👍👍

Thank you so much Sir! very helpful!

Is it possible to lock the size, without having to edit the photos? for example, I have a database with employees, but a few admin using their phones to take pictures of new employees, and everyone uses different phones these days (android vs apple and such) which ends up causing different sizes and resolutions, but say I decide to use the image to print out paper ID cards using the database info and a form with certain certifications, but I need the pictures to be uniform in size (height/width). How would you lock it?

what about adding button to control the inserting or deleting of the file or image from the image control box? Would you mind to show us how to do that.

were you even talking?!? can't hear a thing

How can this be adapted for items that have a varying number of 1 to 5 pics?

Very helpful thanks, some problems with the audio volume.

Difficult to hear you.

Horrible audio!!!

I will be using my database on two different computers, and the path where I will store my image files will not be the same. Do you know if instead of typing the entire path of the image file, I can indicate the path is a specific folder inside the "current path", meaning wherever the database lives on the particular computer I'm using?

Helpful video!!! You should mention to make sure the file extension is added at the end of the file path...an easy thing to forget!!!

thanks, it was very helpful for me.... keep on sharing your knowledge... thanks again.

Access 2007 Table with students with images (folder address&file names) of the classes.All what I need is: filter the table in any form (form, query, report or as table) to transform it into html file with images later. I've learned how to show the images in the form. I've learned how to filter the table. How to put it all together in one table of any form, query, report or table of some sort? Could you make such tutorial please or readdress me to somebody's already made video please?

It worked! thank you so much! It really helped me a lot! God bless.:)

Now, what if you have 100 record, and you want the photo field link address to have a default value from the name field ?
Like : ="\C:\Face Photo\FIRST NAME.jpg"
Is there a way to make "first name" a default value taken from the first name field ?

Thanks for posting but it didnt work in my database - I am using a front / back end scenario and the coding doesnot appear to work

Torzo Tehnology - The volume on this video is very low (at least on my lap top)...It would help immensely if you could re-post this useful presentation with a better sound track.

The information is in the video if you can tolerate the annoying presentation. Very amateurish. An outline and a a modicum of forethought would have made a big difference.

I'm having trouble having the picture show up. All I get is the file name. I'm following exactly what you are doing, but still "blank". Is there something I'm missing?

Thanks.  That was very helpful!

Easy1 Thanks

Awesome! Just what I was looking for and very simple to follow. Great!

Very nice tutorial.