Link to JPG images to use in forms and reports
I am starting an inventory business and have written an Access(XP)DB to hold all the data as well as JPGs of the more valuable pieces. It all works well, but the JPGs in my table are HD HOGs (500K for each 30K JPG). I now see that I should keep the JPGs in a directory and link to them, but I am having a problem doing that. I am using an Unbound Object Frame and can link to a JPG file with no problem, but I can't programatically change the link to the correct JPG for the record. I am changing the value in Source Doc, but that doesn't do anything.