Hello Everybody
My file has a form that displays personal data of every employee and his photo.
When I change the employee Number ,all data +photo change.
Note: photos are named by the employees No.
But when there is no photo for specific employee (like Employee No. 5+6) ,the previous photo still exist.
Required:
I want the photo to be empty when there is no photo for the employee
Find the attachment
Note:Extract the archive in the same folder to view the photos
Please your support
Hi leprince2007,
See the attached file which contains the following code. I added an additional jpg file that indicates there is NO PHOTO on file.
BEFORE USING, The .txt Extension MUST BE removed from file NoPhotoOnFile.jpg.txt to make the file NoPhotoOnFile.jpg. When I uploaded the file as .jpg, ExcelForum insisted on displaying the picture, so it could not be downloaded.
Lewis
Please Login or Register to view this content.
Last edited by LJMetzger; 12-22-2016 at 11:37 AM.
Modify the code as indicated. What this section of code does is check for the existence of the picture and if it does not exist load Blank.jpg. You'll have to develop Blank.jpg.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
well done it worksOriginally Posted by dflak
Modify the code as indicated. What this section of code does is check for the existence of the picture and if it does not exist load Blank.jpg. You'll have to develop Blank.jpg.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks