need to move information easily to the clipboard

[WaltLukeIII]

I have an access database in which I have several custom buttons. I would like to make a button that takes several strings concatenates them and puts them onto the "clipboard".

I can get the string to concatenate and it does it properly. I however have not been able to get the concatenated string to the "clipboard". I want the user to be able to go to microsoft word and just push the past button or hit CTRL+V for pasting. Any Help is always appreciated.

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl

 

[swilliams]

See the thread: thread222-43600 It is detailed there how to do this.

Simon

 

[Guest_imported]

Try the following:
with Text being the string containing the concatenated words

Clipboard.SetText Text, vbCFText

 

[WaltLukeIII]

I could not get the Clipboard.setText command to work However I did get this to work.

Me.Text13.Value = Text0 & (Chr(13)) & Text2 & (Chr(13)) & Text4 & _
", " & Text6 & " " & Text8

Me.Text13.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, acCopy


Thanks for the help though it got me moving in the right direction.

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl