Copy to Clipboard - Copy To Clipboard in Microsoft Access


	Back to Copy To Clipboard Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Copy to Clipboard

Mark Desens

9 months ago

Hi Richard, I’ve learning a lot here and saw your video on copy to clipboard. How do you clear the clipboard using vba? I’ve been researching it and tried just a few but nothing. I need help with clearing it.

Kevin Robertson @Reply

9 months ago

Add this to a Global Module

Private Declare PtrSafe Function OpenClipboard Lib "user32" (ByVal hwnd As LongPtr) As Long

Private Declare PtrSafe Function EmptyClipboard Lib "user32" () As Long

Private Declare PtrSafe Function CloseClipboard Lib "user32" () As Long



Public Sub ClearClipboard()



    If OpenClipboard(0&) Then

        EmptyClipboard

        CloseClipboard

    End If

    

End Sub

Now in a Button on your Form you can call ClearClipboard.

	Mark Desens OP @Reply 9 months ago
Ok Thanks Kevin.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Copy To Clipboard.

Next Unseen

New Feature: Comment Live View