How to display multiple pictures per record in an Access database?

[Wadim Grasza]

I want to store and display (on a form or a report) multiple pictures
per
record in an Access database. The pictures are not stored within the
database. They are stored as files and the database contains the paths
to the
pictures.
The database consists of two tables:

TABLE DATA
ID Name LastName

TABLE PICTURES
ID Path

I want to create a form displaying data for each record of TABLE DATA
and
all the pictures (let's say aligned horizontally) for the particular
record
from TABLE PICTURES (ID <-> ID). MS Access allows subforms to be
added to a
form, but this doesn't solve the case, since subforms can be only
displayed
in data sheet view.

 

[Arvin Meyer [MVP]]

Subforms can be displayed in Single form, and continuous views as well. You
want to set your form up in continuous view. This won't solve the problem of
horizontal display, but you may perhaps be able to change that requirement.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Wadim Grasza]

OK, that helps a lot, but I really need to display the pictures
horizontally. I have also tried creating Image controls dynamically
using VBA, but this won't help, since controls can be created only in
design mode. Is there any other way?

 

[Guest]

You can do it easily in a report by using a multi-columned subreport with the
column layout set to 'across then down'. You'll find an old Access 97 demo
of mine for this at:

http://community.compuserve.com/n/pfx/forum.aspx?msg=19513.1&nav=messages&webtag=ws-msdevapps

It should convert to later versions, I think, but if not post a message in
that form and I'll attch a more up-to-date version to a reply there.