Question re: path I should use when listing file names in a table

[mcomp72]

I need to attach an image file to each record in a table, because I want them to show up in one of my reports. Instead of actually attaching the image, I am creating a ShortText field where I will put the path to the file (which lives on my hard drive). This way the size of my database won't get too big once I have thousands of images attached.

I will be using this database on two different computers, and depending on which computer, the path where the images will be stored will be slightly different.



The two paths will be:

Desktop computer -- C:\Users\Matt\OneDrive\Documents\Images
Laptop computer -- C:\Users\MattC\OneDrive\Documents\Images

(The database itself will live in "\OneDrive\Documents")

I have tried using "\Images\imagefile.png" in the field of my table, but the image doesn't show up on my report. So, what I'm wondering is, how can I list the path so that the images can live inside a folder WITHOUT listing the entire path in my table field? Is that even possible?

BTW, I'm using Access 2016.

[pbaldy]

You can get the path to the database location with

CurrentProject.Path

and just store the path from there. Concatenate them for the full path.

[mcomp72]

Thanks very much for this! I'm still pretty new to Access, so it took me a bit to figure out what exactly I needed to do, but finally got it.

For anyone else reading this who needs to know how to do it, here's what I did:

I went to my report, and went into Design View.

I clicked on the Image box that I had created for where I want my image to appear, then bought up the properties sheet.
I hit the "..." on the line for Control Source, and inside the expression builder, I replaced Image (the field where my path & file name is stored) with CurrentProject.Path & "\Images\" & Image

In the Image field of my table, instead of listing any path at all, all I listed was the file name itself (with extension).

Thanks again, pbaldy!

[pbaldy]

Happy to help!