OLE object is empty

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jenniferspnc - 29 May 2008 15:57 GMT

I have a subform that has many fields from a table, two of which the data
type in the table are OLE objects. So when I'm in the form/subform and click
around I get the error message "The OLE Object is empty. You can't edit a
bound object frame if the field in the underlying table doesn't contain an
OLE Object...." How do I solve this? I want a user to be able to insert an
object if need be but don't want an error message for those that don't have
anything. And then is there a way to get the actual image to display instead
of it just saying what the image type is? Thanks.

Reply to this Message

Fred - 29 May 2008 21:58 GMT

With the possible exception of Access 2007, ole object is a bad way to store
pictures. Better to store it's path and file name in a text field.

Then you want to make it show as a picture in forms (and possible reports).
I learned how to do this in this group of forums in 2007 and 2008 = I search
them. I don't know it well enought to accurately ratte it off, but it's
somehting like coding Me.Image17.Picture = Me.PicturePathAndFile in the forms
"on format" event

> I have a subform that has many fields from a table, two of which the data
> type in the table are OLE objects. So when I'm in the form/subform and click
[quoted text clipped - 4 lines]
> anything. And then is there a way to get the actual image to display instead
> of it just saying what the image type is? Thanks.

Reply to this Message