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

tony_schullo@csx.com

Guest

Posts: n/a

26th Oct 2007

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://vbforums.com/showthread.php?p=2263813

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

« Printing forom different tabs | How to make the sheet index name same as the sheet name after inserting sheets? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select Record in query, save as New Record then edit New Record	spreadsheetlady	Microsoft Access	1	26th Jan 2010 09:41 PM
How edit database on a primary key rather than the record #	=?Utf-8?B?TGluZGE=?=	Microsoft Access Forms	1	7th May 2006 05:13 PM
How do I edit a record in database	Ashish	Microsoft Excel Discussion	7	28th Sep 2005 01:29 PM
how do I edit a record in database	Ashu	Microsoft Excel Programming	2	27th Sep 2005 02:04 PM
How to know who is locking/editing the record in the record edit form?	Cheng-Liang Shen	Microsoft Access	1	9th Oct 2003 08:28 AM