I have written a program in Access that has an ole field in a table
which is created for the purpose of getting an electronic signature for
each record.  In the program I have a form with a bound object frame
connected to the signature field and two command buttons.

The first command button executes an external program call which runs
the signature software.  Once the person has signed the electronic
signature pad the signature image is copied to the computer clipboard.

The second button pastes the image from the clipboard into the ole field
using the acOlePaste command from the Action property.  The problem is
that this only works if the clipboard is empty when the signature is
captured.  If the signature replaces anything then the paste does not
work.

Does anyone know how to empty the contents of the clipboard using VB
code?
Thank you,
Nicole Stephens

<< Does anyone know how to empty the contents of the clipboard using VB
code? >>

Paste this into a module:

Declare Function EmptyClipboard Lib "user32" () As Long

Then, to use it, just:

EmptyClipboard

will do it. Easy, huh?

-------
Regards  Stuart McCall

"Time flies like an arrow,
Fruit flies like a banana"

Hi Nicole,

I think all you should need is a call to this API
Private Declare Function apiEmptyClipboard Lib "user32" _
    Alias "EmptyClipboard" () As Long

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:I have written a program in Access that has an ole field in a table
:which is created for the purpose of getting an electronic signature for
:each record.  In the program I have a form with a bound object frame
:connected to the signature field and two command buttons.
:
:The first command button executes an external program call which runs
:the signature software.  Once the person has signed the electronic
:signature pad the signature image is copied to the computer clipboard.
:
:The second button pastes the image from the clipboard into the ole field
:using the acOlePaste command from the Action property.  The problem is
:that this only works if the clipboard is empty when the signature is
:captured.  If the signature replaces anything then the paste does not
:work.
:
:Does anyone know how to empty the contents of the clipboard using VB
:code?
:Thank you,
:Nicole Stephens
:

Nicole Stephens a crit dans le message

...

Hi Jacques,

Unfortuantely I don't think the Clipboard object is supported under
VBA/Access.

--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:
:Nicole Stephens a crit dans le message

:
:...
:
:>Does anyone know how to empty the contents of the clipboard using VB
:>code?
:Try to manipulate the clipboard with pure VB (4 or 5) code (not VBA) with
:the instruction
:    Clipboard.clear
:As simple as that.
:
:>Thank you,
:>Nicole Stephens
:>
:
: