file path to ole linked objects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leslie - 07 May 2007 19:01 GMT

I have a table that stores employee pictures. The pictures were embeded and
I would like them to be linked. Database will not be moved so I'm not
worried about the folder moving and having to re-map the objects. Because I
have chosen to link to the object, I must go into the table and set the
location. The field does not show path information and I would like to add
this information without having to go thru every record. Does anyone know of
any options available to set the location of linked objects for the entire
database?

Signature

Leslie

Reply to this Message

John B. Smotherman - 31 May 2007 21:32 GMT

Leslie-

If you're still looking for help with this one, I've done something very
similar to this. I have a table with a field called "FileName" that contains
only the names of the image files. There's an additional field called
"PathToFile" which is a combobox that looks up the path name in a join table.
To display the images, use VBA similar to the following:

strImagePathName = DLookup("PathName", _
"jtbImagePath", "PathID = " & Me!PathNameCombo) ' lookup the path
for where the image file is stored
FormName.ImageLabel.Visible = True 'show
the thumbnail label,
FormName.Image.Visible = True 'show
the thumbnail preview box,
FormName.Image.Picture = strImagePathName & FormName!FileName 'and
fill the picture attribute of the thumbnail preview box

This shows the image in a small control I have setup as a thumbnail preview,
but Access takes care of sizing the image to fit. Make it as large or as
small as you like.

HTH

> I have a table that stores employee pictures. The pictures were embeded and
> I would like them to be linked. Database will not be moved so I'm not
[quoted text clipped - 4 lines]
> any options available to set the location of linked objects for the entire
> database?

Reply to this Message