p2p.wrox.com: Archives - access archive

access thread: Empty OLE Object

Message #1 by "George Oro" <george@c...> on Thu, 20 Feb 2003 09:34:11 +0400

I'm using Access(FE) and SQL(BE), Unbound Form using ADO:

Below is my code to empty my form which is working fine except when I added the acImage (Photo) which I don't what is the syntax to
make it empty.

    Dim frm As Form
    Dim ctl As Control
    Set frm = Me

    For Each ctl In frm.Controls
        With ctl
            Select Case .ControlType
                Case acTextBox
                    ctl = Null
                Case acCheckBox
                    ctl = Null
                Case acComboBox
                    ctl = Null
                Case acImage
                    ctl = ?????????????????????????
            End Select
        End With
    Next ctl

I know this is simple but I can't figure out.

Any help would be greatly appreciated...

TIA,
George

Message #2 by "George Oro" <george@c...> on Sat, 22 Feb 2003 10:04:39 +0400

Sorry for re-sending this email, I send this 3 days back and still didn't received.


> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Thursday, February 20, 2003 9:34 AM
> To: Access Help
> Subject: Empty OLE Object
> 
> 
> I'm using Access(FE) and SQL(BE), Unbound Form using ADO:
> 
> Below is my code to empty my form which is working fine except when I added the acImage (Photo) which I don't what is the 
> syntax to make it empty.
> 
>     Dim frm As Form
>     Dim ctl As Control
>     Set frm = Me
>     
>     For Each ctl In frm.Controls
>         With ctl
>             Select Case .ControlType
>                 Case acTextBox
>                     ctl = Null
>                 Case acCheckBox
>                     ctl = Null
>                 Case acComboBox
>                     ctl = Null
>                 Case acImage
>                     ctl = ????????????????????????? 
>             End Select
>         End With
>     Next ctl
> 
> I know this is simple but I can't figure out. 
> 
> Any help would be greatly appreciated...
> 
> TIA,
> George
> 
>

Message #3 by George Oro <georgeoro@y...> on Sun, 23 Feb 2003 06:58:18 -0800 (PST)

Sorry for re-sending this email, I send this 3 days
back and still didn't received.


> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Thursday, February 20, 2003 9:34 AM
> To: Access Help
> Subject: Empty OLE Object
> 
> 
> I'm using Access(FE) and SQL(BE), Unbound Form using
ADO:
> 
> Below is my code to empty my form which is working
fine except when I added the acImage (Photo) which I
don't what is the 
> syntax to make it empty.
> 
>     Dim frm As Form
>     Dim ctl As Control
>     Set frm = Me
>     
>     For Each ctl In frm.Controls
>         With ctl
>             Select Case .ControlType
>                 Case acTextBox
>                     ctl = Null
>                 Case acCheckBox
>                     ctl = Null
>                 Case acComboBox
>                     ctl = Null
>                 Case acImage
>                     ctl = ????????????????????????? 
>             End Select
>         End With
>     Next ctl
> 
> I know this is simple but I can't figure out. 
> 
> Any help would be greatly appreciated...
> 
> TIA,
> George


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

Return to Index

P2P Archives