field (accessible only via a button) or to an attachment in a rich-text field.
This function accesses the clipboard contents of a Win32 computer prior to the
production of an amended computed text field or a new attachment in a rich-text
field.
'---In the Declarations section
Declare Function GetClipboardData Lib "user32"(Byval wFormat As Long) As String
Declare Function OpenClipboard Lib "user32"(Byval hwnd As Long) As Long
Declare Function EmptyClipboard Lib "user32"() As Long
Declare Function CloseClipboard Lib "user32"() As Long
Public Const CF_TEXT = 1
'---make a funtion called RetrieveClipboard
Function RetrieveClipboard () As String
Dim hClipMemory As Variant
Dim MyString As String
If OpenClipboard(0&) = 0 Then
Msgbox "Cannot open Clipboard. Another app. may have it open"
End If
Call OpenClipboard(0)
hClipMemory = GetClipboardData (CF_TEXT)
If Isnull(hClipMemory) Then
Msgbox "Could not allocate memory"
Exit Function
End If
Call closeclipboard
RetrieveClipboard = hClipMemory
End Function
'---Now you can use the clipboard contents in the click event of a button, for
example.
dim doc as NotesDocument
set doc = ...
dim clip as String
clip = RetrieveClipboard
'---Add the clipboard contents to a text field
doc.ProjectNotes = clip & Chr(10) & Chr(13)doc.ProjectNotes(0)
This was first published in November 2000