copy commands

[Guest]

I need to create a button that will copy a highlighted field into my mouse.
We currently right click and click copy, but I would like to streamline the
process. The copying of the fields is a repetitive process we cannot get out
of since we are pasting it to another program. I know cntl C will copy but do
not know how to give a button that command.

 

[Douglas J. Steele]

See whether these KB articles help:

Copying to and Pasting from the Clipboard:
http://support.microsoft.com/?id=138909
http://support.microsoft.com/?id=138910

 

[John W. Vinson]

I need to create a button that will copy a highlighted field into my mouse.
We currently right click and click copy, but I would like to streamline the
process. The copying of the fields is a repetitive process we cannot get out
of since we are pasting it to another program. I know cntl C will copy but do
not know how to give a button that command.

Why use the mouse at all? Tab - Ctrl-C - tab tab tab (to the target field) -
Ctrl-V to paste!

In VBA code you can use

DoCmd.RunCommand acCmdCopy

and

DoCmd.RunCommand acCmdPaste

if the users really find it easier to move the mouse to a keyboard. You will
probably need to SetFocus to the desired textbox first, though - when you
click on the button, IT will have the focus.

Any chance you could export the data into a form the other program can import?
Sounds a whale of a lot simpler than copying each individual field!

John W. Vinson [MVP]