We help IT Professionals succeed at work.

VB6 DAO: Copy record

ttobin333
ttobin333 asked
on
Dear Experts,

Using VB6 with a DAO database, I'd like to copy a record (all fields) in a query/table to another existing record in the same query/table.  Can you please assist?

Thanks!
Comment
Watch Question

There is a good description of how to copy a record between tables here: http://en.allexperts.com/q/Visual-Basic-1048/copy-record-2.htm
Clearly, in your case, you will need just the one recordset.
CERTIFIED EXPERT
Commented:
Does your database table have any unique key constraints?  Usually, a database table has either a single key field (such as an ID field) or a combination of fields that uniquely identify a record in the database.  If your table has such a key fields, you will not be able to copy all fields to a new record because you would be creating a duplicate record.

Author

Commented:
Thanks, guys!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.