Getting an Image into an OLE Field (XP)

Topic

New Reply

I have an application that uses just two images and the client wants to store them in OLE fields. I Have a field for the path to the Image as well.
I allow the user to get the path to the image using a file dialog.

How do I get that image into the OLE field using VBA code. Say in the after update event of the path field.

It is just a bit cumbersome to have the user use the insert from the menu.

Reply | Quote

Replies

You can use code like this, assuming that a picture has already been loaded at least once before:

With Me.oleCtl
.SourceDoc = Me.txtPath
.Action = acOLECreateEmbed
End With

where oleCtl is the name of the OLE control and txtPath is the name of the text box containing the path and filename.

Reply | Quote

Thanks Hans, I’ll give that a go.

Reply | Quote