Macro for copy

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I created many forms and they are using the datasheet view. The question
that continuously comes up is how do we create a key similar to the Cntrl D
function in Excel where it copied just the cell above but in accesses case
the field above? The processors are trying to cut out time and the duplicate
button only works if all fields will be the same. Any suggestions?
 
Have you tried Control plus quote (or apostrophe)? That duplicates the
value in the previous record.

Control + ; gives you the current system date
Control + : gives you the current system time

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
I created many forms and they are using the datasheet view. The question
that continuously comes up is how do we create a key similar to the Cntrl D
function in Excel where it copied just the cell above but in accesses case
the field above? The processors are trying to cut out time and the duplicate
button only works if all fields will be the same. Any suggestions?
Click to expand...

Ctrl-'
 
Is there a place where I can find out what all the short cuts are? Also, can
you change the button you use for ex: change cntrl ' to cntrl d?
 
Like I said

Control + " or Control + '

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
The help lists them. Activate help and search for Keyboard shortcuts.

I'm not sure how to reassign the action.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top