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.

On Sun, 12 Dec 2010 16:07:20 -0800 (PST), Joe Smith <(E-Mail Removed)>
wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

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

"Joe Smith" <(E-Mail Removed)> wrote in message
news:a964a38a-f976-46ec-8c27-(E-Mail Removed)...
>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.