Macro to copy and paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to create a keyboard macro to: a)select the contents of the
current cell, b)copy the contents, c)move down one record in the table view,
and d) paste the contents that was copied.

Using the Create Macro screen, it seemed reasonable to do this in one of two
ways:
Option A: move to start of field, select field using shift-end, ctrl-c to
copy, down arrow to move down, and ctrl-v to paste
{HOME}+{END}^C{DOWN}^V

Option B: (assuming default for field entry is select contents) move up,
move back down, copy, move down, paste
{UP}{DOWN}^C{DOWN}^V

Neither of these options work. When I start in the field that I want to copy
and press the toolbar button for the macro, the contents of the current cell
are erased, the cursor moves down as expected, and nothing is pasted.

If I try immediately pressing CTRL-V to see what has been copied, the
contents of the erased field are not what appears, but rather, it is the last
item that was copied prior to running the macro.

Can someone please help?

Thank you in advance.
 
rather than going to all that trouble, you could just use Ctrl+Apostrophe(')
to copy the value from the field in the previous record to the same field in
the current record. for that and other handy shortcuts, see the Keyboard
Shortcuts topic in Access Help.

hth
 
<blushing>

Wow! THAT IS AMAZING. Thank you so much for that and the reference to the
other shortcuts. I guess, complacency makes me stick with the old standards.
Time for this dog to learn new tricks.

Thanks TINA!
 
you're very welcome :)


Justin said:
<blushing>

Wow! THAT IS AMAZING. Thank you so much for that and the reference to the
other shortcuts. I guess, complacency makes me stick with the old standards.
Time for this dog to learn new tricks.

Thanks TINA!
Click to expand...
 
Back
Top