By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Copy string to clipboard???

P: n/a
Say I have a string value in Access -
perhaps "ABCDE".

How do I copy it to Windoze clipboard?

This is not a repost, but is related to a 7/26/06 post entitled
"Probs running DoCmd.RunCommand acCmdCopy in A97"
Jul 28 '06 #1
Share this Question
Share on Google+
3 Replies

P: n/a
Here is a call to a module routine that does it on a button click:

Private Sub Command11_Click()
On Error GoTo Err_Command11_Click

Call ClipBoard_SetData(Me.fText)

Exit Sub

MsgBox Err.Description
Resume Exit_Command11_Click

End Sub

Here is the entire module that does it:


Option Compare Database
Option Explicit

Declare Function GlobalUnlock Lib "kernel32" (ByVal hMem As Long)
As Long
Declare Function GlobalLock Lib "kernel32" (ByVal hMem As Long) _
As Long
Declare Function GlobalAlloc Lib "kernel32" (ByVal wFlags As
Long, _
ByVal dwBytes As Long) As Long
Declare Function CloseClipboard Lib "user32" () As Long
Declare Function OpenClipboard Lib "user32" (ByVal hWnd As Long)
As Long
Declare Function EmptyClipboard Lib "user32" () As Long
Declare Function lstrcpy Lib "kernel32" (ByVal lpString1 As Any,
ByVal lpString2 As Any) As Long
Declare Function SetClipboardData Lib "user32" (ByVal wFormat _
As Long, ByVal hMem As Long) As Long

Public Const GHND = &H42
Public Const CF_TEXT = 1
Public Const MAXSIZE = 4096

Function ClipBoard_SetData(MyString As String)
Dim hGlobalMemory As Long, lpGlobalMemory As Long
Dim hClipMemory As Long, X As Long

' Allocate movable global memory.
hGlobalMemory = GlobalAlloc(GHND, Len(MyString) + 1)

' Lock the block to get a far pointer
' to this memory.
lpGlobalMemory = GlobalLock(hGlobalMemory)

' Copy the string to this global memory.
lpGlobalMemory = lstrcpy(lpGlobalMemory, MyString)

' Unlock the memory.
If GlobalUnlock(hGlobalMemory) <0 Then
MsgBox "Could not unlock memory location. Copy aborted."
GoTo OutOfHere2
End If

' Open the Clipboard to copy data to.
If OpenClipboard(0&) = 0 Then
MsgBox "Could not open the Clipboard. Copy aborted."
Exit Function
End If

' Clear the Clipboard.
X = EmptyClipboard()

' Copy the data to the Clipboard.
hClipMemory = SetClipboardData(CF_TEXT, hGlobalMemory)


If CloseClipboard() = 0 Then
MsgBox "Could not close Clipboard."
End If

End Function


Jul 28 '06 #2

P: n/a
MLH wrote:
How do I copy it to Windoze clipboard?
Use the appropriate function from this API call on the Access Web:
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Jul 28 '06 #3

P: n/a
Ron - that's a perfect solution.
Many thanks.

DoCmd.RunCommand acCmdCopy is kloogey
and completely unreliable.
Jul 29 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.