Creating a Product Catalog Report in Microsoft Access with Multiple Images (Pictures) Per Record

In this Microsoft Access tutorial, I'm going to show you how to create a product catalog showing multiple images per product. 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 whatever you want. It's basically displaying multiple images per record.

Gilian from Burlington, Vermont (a Platinum Member) asks: 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!

Silver Members and up get access to an Extended Cut of this video. Members will see how to display the products in multiple columns in the report using a subreport.

MEMBERS VIDEO:

BECOME A MEMBER:

LINKS:

LEARN MORE:

RECOMMENDED COURSE:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, image gallery, multiple images per record, CurrentProject.Path, How to create a catalog of products in Microsoft Access, catalogue, How do I make a photo catalog in access, How do I Create a product catalog in Microsoft Access, Help creating a product catalog in Access, multiple columns in a form, report columns, subreports

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[oliviocamacho]

Excellent trainer, congratulations.
Truly exceptional.

[christophernichol]

Great video, when in the Form though is there a way of say double clicking on the image to allow it to open up in another programe ie paint or Adobe etc?

[CsongorBeke]

Hi, is there a way, if the the CustomerID is 1, then import 1.jpg? Or a product No. is 12345, then use 12345.jpg automatically?

[ssdusd]

If I have a form On close event to requery main Form, I want if I didn't make any changes don't requery the main form, how can I do it?

[teresameek]

This is not working for me. Is this because I am using OneDrive to store my database and images?

[faw]

This looks very useful in a genealogy database to show multiple pictures of the person and maybe pictures of his documents (Birth Cert., etc.). How would you add descriptive labels for each? (That would help for furniture, too). Could the pictures be expandable? Great video, but fast. Thank you very much.