This is what I have now.

You can absolutely do this. Store the full path to the original image in a separate field in your table, rather than trying to retrieve it from Excel or reconstruct it later. Then you can either make the image control clickable or add a View Full Size button to your form. When clicked, use the Shell command to open the original image in the Windows default photo viewer, IrfanView, or another application of your choice.

I'm sorry, I don't know how to do that. I am not a Developer. At best, I am a so, so expert. In the past when I had smaller databases, I would just insert a Follow Hyperlink. Knowing how to use the Add Multiple Images method, I know have hundreds records, I can't to those 1 at a time, that is why I was trying to use Excel. I would copy the actual path to the file, and then add the file name. I would then merge those 2 coulmns in Excel into 1 column to have the entire path, then copy that into Access. Access won't let me do it that way.

I have it sort of worked out with the database. I made a button to show the picure in an Image Control in the form, but as I stated, my picture size is 1920 x 1080. I can't seem to make the Image Control big enough to show the whole piture.

Look at the Size Mode property for the Image control (Format tab).

In the past when using Follow Hyperlink, I would click on the Hyperlink, and Windows would just open the file in it's native viewer. That was okay for a few images, but now I have thousands of images. Unless I am missing something, the Image Control is just not big enough.

I now have it set to Clip, Still not quite big enough, but better.

Set to Zoom and the image will keep its aspect ratio, and you will see the entire image in the control.

Thsnk you. Can you tell me what a Return Without GoSub Error is? Everything still works, but now I get that annoying popup, and not always.

Opps... Thank you!

David, glad the photo album is working well! Yes, you can open the original photo without creating thousands of individual hyperlinks. Thanks, Kevin and Alkan, for helping.

Kevin's Zoom setting fits the whole picture inside the image control. Clip shows it at its original size but cuts off whatever doesn't fit. To see it in your normal photo viewer, your FollowHyperlink approach is still useful.

Your screenshot shows that MyImage already contains the filename. You just need to combine that with the folder location for the current record. If you kept the tutorial's Images folder beside the database, a View Photo button's On Click event procedure can use this line:

FollowHyperlink CurrentProject.Path & "\Images\" & MyImage

Put that inside the button's existing Sub/End Sub procedure, not directly in the On Click property box. Test it on a record with a filename and an image that exists. If your pictures are stored elsewhere, use that actual folder instead. One button then works for whichever record you're viewing; there's no need to rebuild the links in Excel. I demonstrate combining the folder and filename around the 10-minute mark in Load Multiple Images, Part 1.

On your new Return Without GoSub question: that message by itself isn't enough to identify what's causing it in your database. What exactly are you clicking or changing when it appears? Please post the complete error text and, if a Debug button appears, the line it highlights, with any personal information removed. Let's identify that before changing more code.

Richard talked about the Return Without GoSub Error in Quick Queries # 106

Kevin's suggestion to use Size Mode = Zoom is correct if the goal is to display the entire image within the Image control while preserving its aspect ratio. However, Zoom only scales the image to fit the control; it does not display a 1920 x 1080 image at its original pixel dimensions.

For a photo album containing thousands of images, I would use the Image control for previewing images and add a button (or use the Image control's On Click event) to open the original file in the default Windows photo viewer. That way, you can browse images in Access and still view the full-resolution photo when needed. I understand that's what you're trying to achieve.

Add a button to your form, use either FollowHyperlink or Shell approach shared in this thread in its On Click event and if your original photos are all stored in the same directory, you can construct the full file path by combining the directory path with the image filename.

Alkan, thank you for you advise. I have never used that type of command before, I wouldn't know how to use it.
  Shell "cmd.exe /c ""C:\My Picture Folder\My Picture.jpg"""
Or where to put in in the database. Put it in the button?
That's what I was trying to do with Excel,
"J:\Database-Copy\ImagesDB\Images\202610151212263.jpg"or J:\Database-Copy\ImagesDB\Images\202610151212263.jpg

I already have this part of the file name in Access, 202610151212263.jpg. I was trying to put this in front of the file name,
J:\Database-Copy\ImagesDB\Images, to get this, J:\Database-Copy\ImagesDB\Images\202610151212263.jpg
and then do copy it from Excel into Access, but Access won't let me do that.

Concatenation

David, if your images folder is located in the same folder as your database, you can use the Shell command as Alkan suggested in the click event of a button or of the image:

Private Sub MyImage_Click()

     Shell "cmd.exe /c """ & CurrentProject.Path & "\Images\" & ImageFileName & """"

End Sub

Replace "MyImage" with the actual name of your Image control or button control and ImageFileName with the name of the field holding the location of your image.

I may have missed something in the video Add Multiple Images. I don't remember if Richard Talked about being able to click either the picture or a link to display the full image, other than that, the datatbase works.

Thank you!

If you like how it's working great! On the other hand, if you'd like to have Access open the image to full size without loading an outside program, it's actually pretty easy with just a tiny bit of code (and a blank form with few or no controls on it).