Clone a record, edit it and add as new record to database.

Clone a record, edit it and add as new record to database.

Post by tony_schul » Sun, 28 Oct 2007 00:34:21


I need to write some vba code to take a record from an ADODB.recordset
and essentially clone/copy it, make changes and add it to the
database.

I found some good code at:
http://www.yqcomputer.com/

that should help with the copying of the record, I think.
But now that I have the new record, how do I write it to the database?

Thanks
 
 
 

1. Default "add record" button edits current record, doesn't add new

2. Select Record in query, save as New Record then edit New Record

Hi,
I have a Select Query with a Split Form attached to it. Access 2007.

I print out single page Lab Test Certificates that are sent out to Customers.

This is done through a Report also attached to the same Query.

When you click on a record visible in the bottom of the Split Form, it shows
in the fields (test boxes) in the upper portion of the form. The report is
created using this active record that is showing in the form.

Sometimes the same Certificate (record) is used again and only certain
fields need changing to create a new one. I would like to keep the old
record with it's original ID number.

Using a Command Button. Would it be possible to copy the selected query
record in the form, then paste it into the next (new) blank record so it may
be utilized as a new certificate for printing?

This is my very first Database. I've always used Excel, so I have some
experience with V.B. but still a novice. I see you cannot record macros in
Access, and I did not see what I wanted to do in the macro builder.

Thank you for your time, and thanx in advance if anyone has suggestions for
this beginner.
Amy

3. adding a new record at subform should update an existing record (not create new record)

4. add new record-if duplicate edit existing record in table

5. Add new record, requery to add to table and then open for returning to new record

6. [Uniface-L] problem in checking a record in the database before adding a new record in

7. problem in checking a record in the database before adding a new record in

8. [Uniface-L] problem in checking a record in the database before adding a new record in

9. Current Record Count, Previous Record #, Add New Record

10. After Adding a New Record it remains the Last Record in Record

11. Need help trying to create a new record based on another records data (cloning ?)

12. Add record to access database - record not added

13. Add new record from a form to a table, then record new ID

14. Q: automatically recording date record was edited/added

15. Hide/Skip Records that have "Edited Records" Record Lock