Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying in Datasheet View (Access97/2000)

    Hello, Can anyone tel me what the key sequence is to copy the row from above to the current record. I had learned it 3 years ago but can'tseem to remember what it is. It was told to us for the duplicate information so we didn't ave to reenter it. It would come in so handy now and I can't find out what it is.... PLEASE HELP..
    Thank you Joanne

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying in Datasheet View (Access97/2000)

    You can copy the value from the previous record (row) in the current field (column) by typing Ctrl+' (Control + apostrophe). I don't know of a keyboard shortcut to copy an entire record (row).

  3. #3
    eLar
    Guest

    Re: Copying in Datasheet View (Access97/2000)

    If you hold the CTRL key down and press the ' (apostrophe) key it will copy the field in the row directly above. Is that what you're talking about?

  4. #4
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Coping an entire row - on the keyboard

    You can copy an entire row and paste it into a new record by selecting the desired row using the record selector (the gray area to the far left if it shows on your form), copy, then select the record selector of the new record and paste.

    You can select the records in two ways:
    1) mouse click on the record selector of the records you are dealing with.

    2) use "Shift-Spacebar" to select the current record. NOTE to use shift-spacebar in the current record, if that record has data in it, you need to have the entire field selected (that the cursor is in) for it to select the record. If the cursor is in the field between two characters then pressing shift-spacebar will insert a space and show a dirty-record symbol.

    Also, once a record is seleced and copied, you can use the TAB key to move to the new (blank) record. Then just paste the copied record in. (ctrl-v).

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Coping an entire row - on the keyboard

    Or whilst holding down the 'alt' key press E G L E L E C E N <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Propbably worthwhile writing a macro and asigning it to a hot key if you do it much!

    HTH

    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •