Question Editing pictures through Access

[Endre]

How does Access know where pictures are stored? When I double click on an image, Access opens up Paint for me to edit my image - but how does it know where to get my image from? I would like a pop-up message box telling my users where the image is located before they edit it....

I have a table with an OLE Object field which I link all my images to. I have a continuous form bound nicely to my table that shows my different images nicely for each record. When I double click on each image, Access runs the associated application (in my case Paint) and opens up the image and I can edit it. I would like a pop-up message to say e.g. [The image you are about to edit can be found at - C:\My_Images\Nice_Images\001_Smiley.bmp]

How can I do this?

 

[oumahexi]

If you inserted the picture as an object (OLE) then it takes you directly to Paint, the way you want to see the path you would need to insert a picture. The latter is not the greatest practice because it makes it more difficult to share your db. Inserting an object embeds the picture so that the compiled version does not need to rely on the path. (I think )

 

[Endre]

Hey Heksie, Thanks for the reply, I do realise that. What I really really want (really really really really want) is for Users to be able to maintain an ImageList of Icons.

The only way I know of users maintaining images is to use an OLE Table field which I can bind and display in a continuous form and this works very nicely thank you very much. So how do I transfer these across to the ImageList?

I don't know of a way of transferring images across from an OLE Object Table field, and the only way I know of loading images into an ImageList at runtime is through the LoadPicture function. And this function requires a file name.

So if I know where the filename is located - I can use it in the LoadPicture function. But I (think) have been through every property and I can't find the file location for the source of the OLE Object.

Currently I have another field that the users also have to fill in and that hyperlinks to the object, and I use that as my source file location. But this could be different to the field that has the source of the OLEObject in it, in which case the ImageList could pick up a different image to that of the OLEObject. (But ssshhh, don't tell the users that)

Any ideas, or can I / should I use a different approach?

(Still smiling with this problem so far.....)