Using Clipboard_SetData function to copy small table

[Peter_W]

Hello,

Within Access 2010. I am familiar with using the the Windows API, and then creating the function, Clipboard_SetData, which will copy some data to the clipboard, when called. Testing this, the function works fine for a small string of data.

However, in my database, I would like to use the Clipboard_SetData function to copy a small, one-column table, called Orders, which is filled with about a dozen, 8-character strings.

So my question is, would anyone have a quick example of the code to do this? I have seen many examples of the function, but the code examples almost always look like like:

Clipboard_SetData ("A single, small string sample like this")

Again, how would I use this function to copy the contents of a table to the clipboard? The table Orders will vary over time slightly, but will always be a single column of strings.

Thank you in advance for any response here.

 

[welshgasman]

Welshgasman, I had a typo in the code. Also, I needed to add MSForms (FM20.dll) under references too. The code works like a champ now! THANK YOU! Made my day, to say the least. Thanks RoryA for the tip. Will have to try ADO some day, but usually I can get the DAO code like this to work. Thanks again!

Yeh, I was going to post the reference required.
If you are using the code you posted, you don't need the parameters. That was so it could be used with any table/query and field.?

 

[welshgasman]

Peter_W,

How did you find the correct reference library for that function.?