Populating the clipboard

[Ash]

I want to populate the clipboard with the value from text board on click.
Please help!

 

[Daniel]

I took this from answer given by Stephen Lebans back in May

DoCmd.RunCommand acCmdCopy

Daniel

 

[Daniel]

I checked out the MVPS website and they have an API for this you might want
to check it out as well,

http://www.mvps.org/access/api/api0049.htm

Daniel

 

[Brendan Reynolds]

There's code to do this at the following URL ...

http://www.mvps.org/access/api/api0049.htm

 

[egerds]

There's code to do this at the following URL ...

http://www.mvps.org/access/api/api0049.htm

How would retrieve the contents of the clipboard?
How to tell if it is an object or text? and if it is text what text it
is?

 

[Brendan Reynolds]

The code at the URL I posted can be used to retrieve text from the clipboard
as well as to copy text to the clipboard. For example, after copying and
pasting that code into a new module, I can copy the contents of a text box
to the clipboard and paste it back into another text box with the following
code ...

Private Sub Command4_Click()

ClipBoard_SetText Me.Text0
Me.Text2 = ClipBoard_GetText()

End Sub

I'm afraid I'm not sure of the answers to the questions about non-text
objects. The code at the URL I posted has a function to copy an object to
the clipboard, but as far as I can see does not have one to retrieve a
non-text object or to identify the format of the clipboard contents. You
could try this list of search results from the VBnet site. (Despite the
'net' in the name, this is not a VB.NET site, it is a 'classic' VB site, and
the code should be adaptable to work with Access).

http://vbnet.mvps.org/index.html

 

[Douglas J. Steele]

You need to declare MyString1 As String, MyString2 As String, etc.

However, the lstrcpy function only takes two arguments: you can't make that
change.