copy to clipboard

[Willem]

Do somebody now how i can copy a selected range of records to the clipboard.
I have made a button whith VB code to copy a record to the clipboard but
when I selected more then one record the records will be unselected when I
clic the button.

Willem
Netherlands

 

[Arvin Meyer [MVP]]

This article on the Access Web may help:

http://www.mvps.org/access/api/api0049.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Allen Browne]

You cannot use the command button on your form, for exactly the reason you
gave.

Instead use a toolbar button, or command button on another form.
The other form would have to set focus to the original form first.
This kind of thing:
Forms!Form1.SetFocus
RunCommand acCmdCopy