create copy/paste button

Question

Good Day

Is it possible to create a 'COPY' and a 'PASTE' button in ms access 2007 on a form or is there any code i could use, or a macro to copy a field and paste a field

thanks it will help me alot

Answer 1

For API code to copy text to the clipboard:

http://www.mvps.org/access/api/api0049.htm

For getting data out of the currently active control, use:

  Screen.ActiveControl.Value

Put these two together and you should be able to figure it out.

If you can't, just post back and I'll provide more detailed instructions.

(there's also DoCmd.RunCommand acCmdCopy, but the data you're copying has to be selected for that to work, so it's actually harder to code that than it is to use the API for the clipboard)