Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Portland, Maine, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Any quick way of copying down data?? Like Excel. (97 SR-2)

    Is there a quick way of copying down the same data for multiple records like dragging in Excel does? There must be a quick way for users to do this while entering data into a table from the table not a form.
    Thanks in advance
    Jols

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Any quick way of copying down data?? Like Excel. (97 SR-2)

    Not that I am aware of, but suggestions that might help are:
    You can copy/paste a record and then change any necessary fields in the new record or the Control Key + the " key (Use Shift to get the double quotes) will copy the same field value from the previous record into the field in the new record.
    Would using default values be useful?

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Any quick way of copying down data?? Like Excel. (97 SR-2)

    Unlike Excel, Access is relational, which means you aren't intended to copy data down into multiple records like that, and it's a very bad idea to have users enter data into tables in the first place because you have limited control over what they can enter and no protection for when they accidentally trash other records. It is, in fact, possible to copy and paste records in a table, but if you can do this for multiple records and not get an error message, it means that your table design is deficient.

    If you explain what you're trying to accomplish, maybe someone someone can suggest some better alternatives.
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Any quick way of copying down data?? Like Excel. (97 SR-2)

    You mean like Ctrl+Shift+"

    ???

Posting Permissions

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