General discussion

Locked

Access 97 record dup /reduce data entry

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?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 record dup /reduce data entry

by kees.valkenswaard In reply to Access 97 record dup /red ...

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.

Collapse -

Access 97 record dup /reduce data entry

by mhoffke In reply to Access 97 record dup /red ...

Poster rated this answer

Collapse -

Access 97 record dup /reduce data entry

by andrew In reply to Access 97 record dup /red ...

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.

Collapse -

Access 97 record dup /reduce data entry

by mhoffke In reply to Access 97 record dup /red ...

Poster rated this answer

Collapse -

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)

Collapse -

Access 97 record dup /reduce data entry

by mhoffke In reply to Access 97 record dup /red ...

Poster rated this answer

Collapse -

Access 97 record dup /reduce data entry

by mhoffke In reply to Access 97 record dup /red ...

This question was closed by the author

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Software Forums