linking to images with std windows dialog box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Stewart - 30 Apr 2006 13:49 GMT

I have an OLE Object field that I want to link to image files on the hard
drive. From a form, I want users to be able to double click the field and
have that bring up a standard windows dialog box to select the image rather
than having to right click the field, select Insert Object and then manually
select "Create from file" and check of "Link". Any thoughts on where to
begin?

Reply to this Message

Haim Rubin - 30 Apr 2006 14:28 GMT

Hi James,

You shall use "Microsoft common dialog control", you can find this
control by press on "More Control" button and scroll down till you'll
see "Microsoft common dialog control 6.0" this button appears right to
the standard controls and it's Icon is similar to the toolbox icon.
In this control you can open a dialog for opening file(actually it's
only get the path that you explorer for), and when you'll select the
file you can get is name(path of thefile) by is property <common dialog
name>.FileName.

Hope I helped, Haim Rubin.

Reply to this Message

pietlinden@hotmail.com - 30 Apr 2006 16:23 GMT

http://www.mvps.org/access/api/api0001.htm

use that, and then just store the file path... store as text, format as
a hyperlink. You might want to check out Randy Birch's site for
converting the paths to UNC paths if they're on networked drives.

Reply to this Message