All my old photo printing databases were too large to post on here, so I created a simple one to demostrate what I am talking about.
The zip file contains the 2 photos that I have used, one is also the "place holder" for the image when it was created, the VBA changes it for the second record. You can change the first record and it will also change the image.
There is the code in the Form's "on Current" Event and also the the Report Detail "On Format" Event as well.
You will of course have to put them in your Folder and change the File Path to suit.
So it will crash when you open the database because the form can't find the Photos until you add them to your folde and also change the file paths in the File Paths Table.
Reply With Quote