General discussion

  • Creator
    Topic
  • #2101107

    Access 97 record dup /reduce data entry

    Locked

    by mhoffke ·

    Does anyone know how to get Access 97 to duplicate a record to reduce data entry? Dbase had the set carry on, is there anything I can do to accomplish this?

All Comments

  • Author
    Replies
    • #3691370

      Access 97 record dup /reduce data entry

      by kees.valkenswaard ·

      In reply to Access 97 record dup /reduce data entry

      Well, that is the old problem I have experienced many times myself. Access requires a complete different way of thinking compared to dBase.
      Is looks as if you have only one table in your database. In Access one has a different table for info that is directly dependent on a primary key. If required use link-tables to combine the whole story. E.g. a table employees, a table courses and a link table just containing the keys in both tables and perhaps a finish date. With one query find out how many courses Pete has followed and with another one who has followed the course Access for advanced dummies.
      By using lookup tables it is easy to enter data in a field, that is the real key is entered in the table and one sees the content of other fields. Making clever queries on which a form is based one gets auto-fill for many fields. In forms it is not too complicated to use macro?s or VBA for auto-fill depending on the content of certain fields in another table.
      In a table use CTRL ? or CTRL? to copy the info from the field above. Select a whole record, copy and paste it [CTRL C and V. More records with the special Add by pasting option, etc.
      In conclusion I am afraid you would first have to redesign your database before the correct answer can be given. If you rate me possitive and add your e-mail address to your rating comment I would e-mail you and discuss your design.
      Good luck.

    • #3691304

      Access 97 record dup /reduce data entry

      by andrew ·

      In reply to Access 97 record dup /reduce data entry

      What exactly do you mean by ‘duplicate a record’? Do you want to make an exact copy (all fields) of a row and save to the same table? That doesn’t seem like something you would want to do.

      So you want to duplicate certain fields for use in a new record? This makes sense, and I think can be handled by your front end.

      Any clarification you can add will be helpful.

    • #3610713

      Access 97 record dup /reduce data entry

      by articulated mandible ·

      In reply to Access 97 record dup /reduce data entry

      Try adding a command button with the following code:

      Private Sub myButton_Click()
      DoCmd.RunCommand acCmdSelectRecord
      DoCmd.RunCommand acCmdCopy
      DoCmd.RunCommand acCmdPasteAppend
      End Sub

      If you are using an autonumber field as yourprimary key, this will copy the entire current record (EXCEPT the PK) diplayed on the form, duplicate it, and add it as a new record as a new record. It also takes you to this new record.

      If your primary key is NOT an autonumber, you may want to add a few additional lines such as:

      myForm!PKTextBox.GotFocus
      myForm!PKTextBox.Value = Null

      so the user doesn’t forget to add the appropriate value (account number, or whatever your PK is)

    • #3635863

      Access 97 record dup /reduce data entry

      by mhoffke ·

      In reply to Access 97 record dup /reduce data entry

      This question was closed by the author

Viewing 3 reply threads