Linked Object

[TDS]

I have a table where there is one record for each address of misc houses
(could be hundreds). One of the fields contains the name of a picture
(1.jpg, 2.jpg Etc) witch corresponds to a picture located in a separate
folder on my hard drive. I would like to link (not embed) each picture so
that I can build a form on that table that will show the picture.

Any help would be appreciated.

Terry

 

[Allen Browne]

Use the Current event of the form to set the Picture property of the image
control.

Details in the links here:
Handle/Display images in forms/database
for a few leads on how to do this.
http://www.mvps.org/access/forms/frm0030.htm

Note that Access 2007 can do this without code. In the new version, the
Image control has a Control Source property. Point it to the file name, and
the image displays automatically, without code, even in a continuous form.