Use a command button to paste record field onto clipboard

[jbickl]

Hello,

Basic: On a continuous form I want to have a button next to each record, which when pressed inserts a particular field from that record onto the clipboard.

Detailed: Every record in my table, tblRequisitions, has an associated hyperlink stored in a field "Hyperlink" (the hyperlink is different for each record). The users want a convenient way to copy the hyperlink so that they can paste it outside of Access. Instead of putting the entire hyperlink as a textbox, I want to display a convenient button for each record entry on the continuous form. When the user clicks this button, I want Access to put the associated hyperlink for that record in the clipboard.

First: Is this possible? Second: How do I do it?



Any guidance is much appreciated.

Thanks!

[aytee111]

I have no idea how to do that, but couldn't you do the paste part as well? Where is the user pasting it? Couldn't you open the relevant hyperlink using Shell thereby saving the user having to paste it themselves?

[jbickl]

The user is pasting the hyperlink in different ways: word documents, excel spreadsheets, and emails.

Solved it:

Me.(OBJECT).SetFocus
DoCmd.RunCmd acCmdCopy

[RuralGuy]

Excellent! Are you ready to use the Thread Tools at the top of the thread and mark this thread as Solved?