Hi- I'm using an append query to move 37 fields from a temporary table to a permanent record. During testing and validation of the underlying code I found that on the second run of the append query I get the following message: "You copied a large amount of data onto the Clipboard"
I have tried to use the following to no avail:
Public Declare PtrSafe Function OpenClipboard Lib "user32" (ByVal hWnd As LongPtr) As Long
Public Declare PtrSafe Function EmptyClipboard Lib "user32" () As Long
Public Declare PtrSafe Function CloseClipboard Lib "user32" () As Long

Public Function ClearSystemClipboard() As Boolean
    On Error GoTo ErrorHandler
        Call CloseClipboard
        ClearSystemClipboard = True
Exit Function

Maybe I'm being dense but I can't seem to get it to work. Any help would be appreciated in clearing the clipboard or suppressing the message without resorting to manually going into settings