Macro for copy

[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?

 

[John Spencer]

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
'====================================================

 

[LG]

That works well but what about for Last_Name or City that is in the filed
above?

 

[John W. Vinson]

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?

Ctrl-'

 

[LG]

Thank you so much. Everyone is a big help in this online discussion group.

 

[LG]

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?

 

[John Spencer]

Like I said

Control + " or Control + '

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

 

[John Spencer]

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
'====================================================