PDA

Click to See Complete Forum and Search --> : Code for CTRL+'

carbo
May 28th, 2006, 09:34 AM
Is there a way perform CTRL+' with vba code in MsAccess 2000

Carbo

CTRL+' copies data from a field in the previous record to that field in the current record.
RobDog888
May 29th, 2006, 02:49 AM
Use the .Copy function of the range object instead
'copy row 1 and paste into row 2
Workbooks(1).Sheets(1).Rows("1:1").Copy Destination:=Workbooks(1).Sheets(1).Rows("2:2")