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
'====================================================
 
That works well but what about for Last_Name or City that is in the filed
above?
 
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-'
 
Thank you so much. Everyone is a big help in this online discussion group.
 
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
'====================================================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting cell contents into a macro 1
Shortcut key for various programs 4
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
button names changed on copied sheet 4
Copying Data 6
Copying Row Code Doesn't Copy Conditional Formating 10
upon submit, run duplicate query and display a pop up listing of d 2
Is there a one button shortcut for "copy cell above & paste here" 4

Back
Top