copy variable to clipboard

  • Thread starter Thread starter Terry Holland
  • Start date Start date
T

Terry Holland

Im struggling with a seemingly simple task. I want to implement a Copy
function in an application that will compile a the fields of a record into
a variable and them place this variable onto windows clipboard. ie
something like this

Sub CopyRecord

Dim strClipboard As String

strClipboard = Me.task_lng_id & vbTab
strClipboard = strClipboard & Me.txttask_dte_logged & vbTab
strClipboard = strClipboard & Me.txttask_txt_title & vbTab
strClipboard = strClipboard & Me.txttask_txt_description & vbTab
strClipboard = strClipboard & Me.txttask_mem_notes & vbTab

DoCmd.CopyToWindowsClipboard strClipboard

End Function

could someone tell me how to do this as I cant find a function similar to
CopyToWindowsClipboard


tia

Terry Holland
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying data in a sheet to a new Word document problem 1
Using a macro to copy text onto the clipboard 1
Copy a Variable to the Clipboard 1
How To Use Redemption To Save Attachments 2
Auto_open and environ variable error cannot find library 2
FAXCOMEX to monitor outbound fax jobs 1
How to simply check to see if clipboard is empty 2
Copy contents of variable into clipboard 6

Back
Top