A student recently asked me this question which I'm going to be using for an upcoming TechHelp video, Extended Cut, and Developer class. I spent all day playing with the Developer solution, and by the time I was done I was too tired to record the videos, so I figured I'd share this here now in case anyone has any ideas or comments for things you'd like to see added.

Here's the question:

I'd like to create a report that I can print out or send as a PDF to my customers showing each of my products. I've used your technique from the Images video to display pictures and not store them in the database. That works great, however is there any way I can show multiple images per product? I sell furniture, and sometimes the customer wants to see the same item from multiple angles. Thanks!

So the basic TechHelp video is going to cover putting multiple images into a form with a subform, and creating a simple report to show the images using a grouping level. Yeah, we're going to cheat and use a customer form, but the concept is the same whether it's products, customers, employees, properties, or whatevever you want. It's basically displaying multiple images per record.

Then the Extended Cut is going to cover creating a subreport with multiple columns, which I don't have a TechHelp for yet, but I cover in Access Expert 7 and Expert 9:

Now here's the cool / tricky part. The upcoming Developer lesson is going to include displaying the images in a subform in columns. This took some VBA trickery, including some recordset magic, but I finally got it to work:

You can click on one of the images to see / edit / delete it:

I got it working like a champ. I included the File Picker code from the Code Vault too. So if any of you have any suggestions for additional things you'd like to see, let me know.

Developer Students: your homework is to try to figure out how I did this before I post the video, which will probably be on Tuesday, since Monday is a holiday.

Good luck!

Update

The course that covers how to do this is Access Developer 38.