I have a MS access Developed Database where part of it users open a dialog box and choose .jpg files to be copied and renamed to different location, I Need VBA Code to health check these .jpg files and Apply Photo Compression them. without loosing much of the quality... slimier example of original photos b4 compression and after is below.
Steps should be as following
1- Health check all photos to be used. if errors found prompt a msg saying "Photo Name" is corrupt. Yes to continue without using the corrupt photo. No to cancel.
2- Check for every photo size if bigger than 1MB then apply compression.
on error leave an error msg.