Adding image that changes from record to record in a form or report

Question

Hello everyone out there.

In my form and report, I have image that changes for each record with the image path store in a text field in a table.

The images are displayed well and changes per record but when I use the database on another system with the image path possibly on a different directory, it gives error and doesn't work again unless I change the image path for each record

How can I have the image saved for each record and display it even on any system without issues?

Answer 1

I agree with Tom's solution, but this needs some planning. You need to define what path the files are in on your PC and what path they may be on another PC.

Another solution would be to store the images in a subfolder of the folder the Access app is in. Then you could use the Project path to generate the image path.

Answer 2

By storing a relative path.

So rather than c:\users\myname\pics\2022\1.jpg and c:\users\myname\pics\2023\2.jpg

you would set the path to:

2022\1.jpg and 2023\2.jpg

Then additionally you have a tblSystemSettings, with the path to the parent folder, in your case: c:\users\myname\pics\ and in the other user's case it will be different; maybe c:\users\hername\pics. You would read system settings into global variables at startup time.

So with 1 change you have configured the app to run with ANY folder tree.

Of course, you now have to concatenate the two strings to arrive at the full path.

Answer 3

Sorry, but no. There is not enough time in the day. If my instructions are unclear, ask specific questions. If you feel overwhelmed, maybe hiring the necessary talent is the best idea,

Answer 4

You need to explain how the images are stored now.

Answer 5

Thanks a lot for your prompt response and the solution you have proffered.

However, this seems difficult for me to implement.

Can you help me with any sample database that illustrates this or the steps to build the technicalities into my database.

Again, thanks a lot