General discussion
-
CreatorTopic
-
August 30, 2001 at 1:52 am #2101107
Access 97 record dup /reduce data entry
Lockedby mhoffke · about 22 years, 7 months ago
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?
Topic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
August 30, 2001 at 5:01 am #3691370
Access 97 record dup /reduce data entry
by kees.valkenswaard · about 22 years, 7 months ago
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.-
October 1, 2001 at 7:31 am #3635864
Access 97 record dup /reduce data entry
by mhoffke · about 22 years, 6 months ago
In reply to Access 97 record dup /reduce data entry
Poster rated this answer
-
-
August 30, 2001 at 6:34 am #3691304
Access 97 record dup /reduce data entry
by andrew · about 22 years, 7 months ago
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.
-
October 1, 2001 at 7:31 am #3635865
Access 97 record dup /reduce data entry
by mhoffke · about 22 years, 6 months ago
In reply to Access 97 record dup /reduce data entry
Poster rated this answer
-
-
August 31, 2001 at 6:20 am #3610713
Access 97 record dup /reduce data entry
by articulated mandible · about 22 years, 7 months ago
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 SubIf 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 = Nullso the user doesn’t forget to add the appropriate value (account number, or whatever your PK is)
-
October 1, 2001 at 7:31 am #3635866
Access 97 record dup /reduce data entry
by mhoffke · about 22 years, 6 months ago
In reply to Access 97 record dup /reduce data entry
Poster rated this answer
-
-
October 1, 2001 at 7:31 am #3635863
Access 97 record dup /reduce data entry
by mhoffke · about 22 years, 6 months ago
In reply to Access 97 record dup /reduce data entry
This question was closed by the author
-
-
AuthorReplies