Clear Clipboard in Access 2000 (Microsoft Access)

Clear Clipboard in Access 2000
message from Ricardo on 13 May 2004
Hi, How does one clear the Clipboard in Access 2000? The good old "Application.CutCopyMode = False" doesn't work anymore. I would appreciate some help. Thanks, Ricardo

Stephen Lebans replied to Ricardo on 13 May 2004

' Place these API declarations at the top of your Form in the General
Declarations area.
Private Declare Function OpenClipboard Lib "user32" (ByVal hWnd As Long)
As Long
Private Declare Function CloseClipboard Lib "user32" () As Long
Private Declare Function EmptyClipboard Lib "user32" () As Long

Private Sub cmdClip_Click()
On Error GoTo Err_cmdClip_Click

' Open, Empty and Close Clipboard
' No Clipboard API error handling
Call OpenClipboard(0&)
EmptyClipboard
CloseClipboard
MsgBox "ClipBoard Cleared!"

Exit_cmdClip_Click:
Exit Sub

Err_cmdClip_Click:
MsgBox Err.Description
Resume Exit_cmdClip_Click

End Sub

Ricardo replied to Stephen Lebans on 14 May 2004

Thanks Stephen,

that worked out just I expected it to!

Regards,
Ricardo

"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com> wrote in message news:<eermUWSOEHA.3096@TK2MSFTNGP09.phx.gbl>...

Archived message: Clear Clipboard in Access 2000 (Microsoft Access Forms)