7/24/2023 0 Comments Imageframer serialThanks again – I'm off to search on how to show the record numbers (record x of y), so I can get rid of the default one. If my thinking is correct, the code provided by MajP will show the default image if the image path automatically created does not lead to an image (for example, I have entered the tool but not yet taken the picture). ![]() Is there any way to have the field ImagePath automatically created from the serial number? At the moment, I have set a default value for ImagePath, so that it enters "D:\Tools\Images\" and I then add the image name. So, if the serial number is ABC123 then the image will be called ABC123.jpg and the FilePath will be set to D:\Tools\Images\ABC123.jpg To make life simpler, I am naming the image files so they are the same as the serial number for the item. I am not very knowledgeable when it comes to the code used in Access and represent the classical cut and paste user! As such, I am wondering if I can ask another question that related to this subject – rather than opening another thread: I have used your code, which now means that I don't have to add the default image to each record where an image does not yet exist. ![]() I created this to overcome the problem associated with the image of one item being displayed for subsequent items (when no image existed). MajP – I already had a default image, which displays when no image for the item exists. This explained why it stopped working when the database was closed. It was obviously linking the path to the default image that I was selecting to create the ImageFrame. ![]() Dhookom - I had not included the full path to the image and changing the database to reflect this has solved the problem.
0 Comments
Leave a Reply. |