using an Update Query to add an OLE object

[Guest]

Ok, here's my problem. I'm trying to use an Update Query and or Macro to use data from one field to update the OLE object in my OLE field. Here's what happens:
In my form, the field titled "Art Code" will be updated and then I have an OLE field set up to display the corresponding TIF file. As of now, I have to manually insert the TIF into the OLE field. What I want is to have the OLE field look at what name is in the "Art Code" field and automatically insert the link in the OLE field to display the image.
I know how to perform an action upon doing an update, but I can't figure out how to get the Update Query to work right. Maybe that's not the correct way to go. Suggestions??

 

[John Nurick]

Hi Matt,

You can't do this with just an update query; the only remotely
convenient way of working with the contents of an OLE field is via a
ObjectFrame control on a form, bound to the field.

In general, you're probably better off not storing the TIFFs in the
database at all. Leave them as files on disk and just store the paths
and names in the table; then display them as needed. Take a look at
Arvin Meyer's PictureMgr sample database here
http://www.datastrat.com/DataStrat2.html to see some of the techniques.