Print selected ID photo based on student ID entered

******MILLIONS THANKS TO GENIUS BAKERMAN2 FOR YOUR SUPER QUICK HELP. YOUR CODE WORKS LIKE A MIRACLE. GOD BLESSS YOU FOR KEEPING YOUR PROMISE TO HELP WITH MY WORK. ******


Hi Super coders

Hope you are all well.
I need your help please.
Attached is the program that requires coding so that user can print the Student ID photo on the Photo ID printer.
SEARCH - User will need to enter Student ID to display the record if existing.
ADD - allows user to add new picture into the existing
PRINT PREVIEW - 7 pictures ID size with the Student ID, Name, Date picture taken.

Thank you so much for your help.

I would strongly advice against putting pictures in an excel file. It will become massive.
Put all pictures in 1 specific directory. Name them,starting with the student ID and maybe date taken.
In your file create a userform with a TextBox, ListBox, CommandButton and an Image Control. Use the TextBox to search for an ID and the ListBox displays all results found.
Click a filename to get a preview in the Image Control. When found click the CommandButton to transfer the selected image to the worksheet to be printed.

thank you so much bakerman2 for your super quick help as always. I will create the userform as suggested. All the stars rep to you for your wise suggestion.

I updated the workbook that I just completed all the buttons. Sleep well. Thanks a lot for your kind, quick help as always bakerman2.

I already created 1 for you to try.
In the Userform chage path to photos. Change Id in B1 to start everything.
Make sure photos are saved as IDnumber and date like 100A_10052024 or 431B_0316/2024.
Select 1 of the photos in Listbox to get a preview, pressing Confirm puts them on the worksheet.

Nice to hear.
Also put next code in ThisWorkbook module. It will clear Image controls before closing the file to keep filesize to normal.

Please Login or Register  to view this content.

Can't you just post the workbook containing Userform here ?

Follow the link in the yellow banner at the top of this thread for instructions on how to attach a sample workbook.
PS: You already posted 2 example files in this thread so what seems to be the trouble ?

It's almost 3 AM over here so of to bed. I'll have a look tomorrow if that's ok for you.

Yellow button opens DataEntry form.
Check 1st row of database. I,ve entered a student ID and path to photo. Adjust for testing purposes.
You can either use Upload Image button to select random photo and PrintPreview button to view PrintPreview or enter Student ID and press Search button (photo gets autoloaded).
Press PrintPreview button to view PrintPreview.

Hi Jojo,

the code of bakerman2, but like this:

Please Login or Register  to view this content.

BR, Alexandra

Or this one.

Please Login or Register  to view this content.

Thank you so much Alexandra for your code. stars added to your hard work. Genius bakerman2's code works like miracle saving my life. I did change the word to the sheetname after running the code. I'd appreciate your help.

Make sure photos are stored in the format StudentID_Date taken without backslashes e.g. 100A_10052024.jpg

I've taken a closer look at your code and I think I figured out your MO.
In the attachment fill out all student details and then click Upload Image. After that click Save.
After that you can enter that Student ID in the search textbox and click Search. All should appear just fine. Now click Print Preview.
Use only numeric student ID.

Thanks for your kind words.
You may also have noticed I've fixed the Listbox and 2 Buttons below.
First select a row in the ListBox , the Edit button then transfers all data to the Textboxes above.
Selecting a row and clicking the Delete button removes the selected row from the database.
The Textbox can be used to Filter the ListBox by LastName. Start typing the LastName, the more you type the finer the ListBox gets filtered.