Displaying Multiple Photos on a single form

[Guest]

I'm working in Access 2003 and I would like to link several pictures to a
single record. I think I’m all set with linking the image file(s) to the
data record. However, I’d like to show a form with the header data and a
sub-form of thumbnail images laid out five across with as many rows as
necessary. When the user selects a thumbnail by a single or double click I’d
like the image to display in the entire sub-form area.

I’ve looked at several sample databases and I did not find one that showed
more than one photo at a time on a form… Any help would be appreciated…

Thanks in advance,

Jim

 

[bob]

You can create a fixed grid of image controls, and then create an ADO recordset in code to load the controls
(and use paging to cycle through multiple pages if necessary).

This sample illustrates this technique used in an application:
http://www.ammara.com/support/samples/showsamf3bc.html

This sample focuses on just the image grid part:
http://www.ammara.com/support/samples/showsam084d.html

Note that these samples are based on our own image control, but the technique can be easily adapted to
other approaches. The second sample demonstrates the technique for both external (linked) images and for
images stored in the database.