OLE Object Has Object?

[Neil]

How can one determine in code if an OLE Object type field has an object for
a particular record?

Thanks.

[Stephen Lebans]

If you have a Bound OLE Frame control on a Form then something like:
If NOT (IsNull(Me.NameOfYourOLEFrameControl.Value))

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Neil" <no****@nospam.net> wrote in message
news:u%*****************@newsread3.news.pas.earthl ink.net...

How can one determine in code if an OLE Object type field has an object for a particular record?

Thanks.

[Neil]

IsNull() was, of course, the first thing I tried. Returns False whether
there is an embedded object or not. Also tried all the other Is...()
functions (well, OK, I didn't try IsNumeric(), but, hey).

I was using "IsNull(Me.Picture)" (the name of the control). I tried what you
had with .Value at the end, but got a compile error: Invalid qualifier.

So, no matter what I try, I can't get find a way to differentiate between
when there is and isn't an embedded object.

Neil
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:TC*******************@ursa-nb00s0.nbnet.nb.ca...

If you have a Bound OLE Frame control on a Form then something like:
If NOT (IsNull(Me.NameOfYourOLEFrameControl.Value))

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Neil" <no****@nospam.net> wrote in message
news:u%*****************@newsread3.news.pas.earthl ink.net...

How can one determine in code if an OLE Object type field has an

object for

a particular record?

Thanks.

[Lyn]

I have just been through coding this type of thing for the first time. The
following snippet worked for me:

If Not IsNull(Me!Photograph) Then
stDocName = "frmPhotoUpdateDelete"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If

This code is executed if you double-click on the photograph object frame.
If there is a picture, it opens a form where you can update or delete the
picture. If there is no picture, of course it does nothing.

HTH

--
Cheers,
Lyn.

"Neil" <no****@nospam.net> wrote in message
news:ny*****************@newsread1.news.pas.earthl ink.net...

IsNull() was, of course, the first thing I tried. Returns False whether
there is an embedded object or not. Also tried all the other Is...()
functions (well, OK, I didn't try IsNumeric(), but, hey).

I was using "IsNull(Me.Picture)" (the name of the control). I tried what
you had with .Value at the end, but got a compile error: Invalid
qualifier.

So, no matter what I try, I can't get find a way to differentiate between
when there is and isn't an embedded object.

Neil

[Stephen Lebans]

Neil the code is correct. Are you sure you have a Bound OLE Frame
control on the form containing the code I posted?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Neil" <no****@nospam.net> wrote in message
news:ny*****************@newsread1.news.pas.earthl ink.net...

IsNull() was, of course, the first thing I tried. Returns False whether there is an embedded object or not. Also tried all the other Is...()
functions (well, OK, I didn't try IsNumeric(), but, hey).

I was using "IsNull(Me.Picture)" (the name of the control). I tried what you had with .Value at the end, but got a compile error: Invalid qualifier.
So, no matter what I try, I can't get find a way to differentiate between when there is and isn't an embedded object.

Neil
"Stephen Lebans" <Fo****************************************@linval id.com> wrote in message news:TC*******************@ursa-nb00s0.nbnet.nb.ca...

If you have a Bound OLE Frame control on a Form then something like:
If NOT (IsNull(Me.NameOfYourOLEFrameControl.Value))

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Neil" <no****@nospam.net> wrote in message
news:u%*****************@newsread3.news.pas.earthl ink.net...

How can one determine in code if an OLE Object type field has an

object for

a particular record?

Thanks.

[Neil]

The problem was apparently a reserved name conflict. As I noted, my control
name was "Picture." When I changed it to "Picture1", IsNull() worked
correctly with it. When it was named "Picture," IsNull() always returned
False.
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:XU*******************@ursa-nb00s0.nbnet.nb.ca...

Neil the code is correct. Are you sure you have a Bound OLE Frame
control on the form containing the code I posted?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Neil" <no****@nospam.net> wrote in message
news:ny*****************@newsread1.news.pas.earthl ink.net...

IsNull() was, of course, the first thing I tried. Returns False

whether

there is an embedded object or not. Also tried all the other Is...()
functions (well, OK, I didn't try IsNumeric(), but, hey).

I was using "IsNull(Me.Picture)" (the name of the control). I tried

what you

had with .Value at the end, but got a compile error: Invalid

qualifier.

So, no matter what I try, I can't get find a way to differentiate

between

when there is and isn't an embedded object.

Neil
"Stephen Lebans"

<Fo****************************************@linval id.com>

wrote in message news:TC*******************@ursa-nb00s0.nbnet.nb.ca...

> If you have a Bound OLE Frame control on a Form then something like:
> If NOT (IsNull(Me.NameOfYourOLEFrameControl.Value))
>
> --
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Neil" <no****@nospam.net> wrote in message
> news:u%*****************@newsread3.news.pas.earthl ink.net...
>> How can one determine in code if an OLE Object type field has an
> object for
>> a particular record?
>>
>> Thanks.
>>
>>
>