I have a database that I use to make Accountability Cards for evacuation purposes. These cards have the photos of the employees on them. I am in the process of incorporating the Accountability Cards into our Employee Database...seems silly to have two different databases to hold information about our employees and my coworkers think it would be a great idea to be able to pull up someones record in the Employee Database and see their picture (Will have to figure out how to block mine haha).
I saw that you can use CurrentProject.path to get the path of the database. If I stored the pictures in the same folder as the database (in a folder called Pictures), could I use CurrentProject.path to help me show the pictures of the employees? One of the reasons I want to be able to do this is if for some reason they need to move our folder on the network the drive may change names (from rdc1 to HarryTheHamster) and I don't want to have to go in and find all the places in my code where I use rdc1 (not that there are very many, but if I win the lottery I won't be here to fix their broken picture links).
Is using CurrentProject.path for this possible (and not really complicated)?