displaying related images in access 2003 forms

[Joe Smith]

I need to display related images on access 2003 forms. I know 2007 is
better at doing this because of the new attachment datatype, but I'm
using user level security so I'm stuck with 2003. The images need to
be in a relationship with the record I'm displaying in the form.

Any suggestions of how to get this done would be greatly appreciated.
THanks in advance.

 

[John W. Vinson]

I need to display related images on access 2003 forms. I know 2007 is
better at doing this because of the new attachment datatype, but I'm
using user level security so I'm stuck with 2003. The images need to
be in a relationship with the record I'm displaying in the form.

Any suggestions of how to get this done would be greatly appreciated.
THanks in advance.

A bit vague about how the relationships and images are connected but... one
thing you can do in any version of Access is use a Text field storing the
filename (and the path to the folder containing the filename, in the same or
another field, if appropriate); you can then use code in the form's Current
event to set the Picture property of an Image control to the filename.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Access Developer]

There are imaging examples that you can download from
http://accdevel.tripod.com/imaging.htm, examine them, and pattern your
implementation on the examples.

Larry Linson, Microsoft Office Access MVP