How to link picture to OLE data field in VBA? 1

[brimes2]

I have a field in a table of data type OLE Object. I can open the table in table view, right click and choose Insert Object, then choose Create From File, Linked and choose a graphic file (bmp, tif, etc.).

How do I do this in VBA code?

rs.mypicturefield...?

 

[kjv1611]

Not 100% sure if I've ever specifically tried this, but this tutorial looks promising for your purposes:

http://www.everythingaccess.com/tutorials.asp?ID=Reducing-OLE-Linking-Overhead

Check it out, and let us know if that is what you're looking for, or if you need to do something else.

--

"If to err is human, then I must be some kind of human!" -Me

 

[brimes2]

Thanks for the post. It's an alternative way to do what I'm trying to do. A good Plan B.

I'd still like to store the linked file using VBA.

Brooks

 

[kjv1611]

So, you're saying you want to actually move a file from one location to another (say an "Images" folder), and THEN link to the file from your table?

If so, try looking at the FileSystemObject. You can Google FileSystemObject as well as FSO in relation to Access VBA.

--

"If to err is human, then I must be some kind of human!" -Me