Copy a string variable to the clipboard

[Duncs]

Based on the contents of controls on my form, I have constructed a
text string that contains the information, as follows:

strClipText = "Transactions Process." & vbCrLf & _
"Information sent to release payments for
Acct= " & Me.txtAcct.Value & " from " & Me.txtFirstPaymentDate.Value &
vbCrLf & _
"Payments for Acct= <<Acct Num for foreign
account>> transferred to Acct= <<Acct for foreign account>> (Code=
<<Code for foreign account>>" & vbCrLf & _
"<<Your Name>> / <<Your Manager>> / Account
Processing." & vbCrLf

What I want to do now is, copy this text to the clipboard so that
agents can paste it directly into a contact note, thereby reducing
their processing time and limiting the possibility of errors.

My question is, how can I do this?

Many TIA

Duncs

 

[Mr. B]

Here is a link that might help you:

http://www.dbforums.com/microsoft-access/526194-copy-clipboard-function-vba.html

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Duncs]

Cheers Mr.B...it works a treat!!!

Rgds

Duncs