Access 2000 - Copy data to clipboard using VBA 1

[BSman]

I have a button with a hyperlink to a site that requires the user enters a list identity to display the right set of data. (It's a CPI index.)

If possible, I'd like to copy the list identity (which is in a column in my data table in Access) to the clipboard using VBA code so that when the user clicks on the hyperlink command button and is taken to the web site, they can just paste the list identify from the clipboard.

Can this be done?

 

[jrbarnett]

Hi,

A single item of data can be copied to the clipboard with:

DoCmd.RunCommand acCmdCopy

having previously set focus to the field which contains the data.

but if you want to copy a whole table it is a bit more involved.

John

 

[BSman]

John,

Thanks. That does exactly what I need.

Bob