how to copy 1 record in ADODB.Recordset

Posted on 2009-02-16
Last Modified: 2012-05-06
How can I do to copy 1 record in a ADODB.recordset?
Question by:bobdylan75
    LVL 4

    Assisted Solution

    what do you mean by copy?

    Author Comment

    I've a recordset that have 3 records.
    I want to copy A in D.
    so it will have 4 records: A,B,C,D.
    and the values of fields of D are like A ones.
    I ask if there are a command or a metods to use to make these,
    a metods as "update","delete","addnew", I think somethink like "copy"

    Accepted Solution

    If nobody else have an idea.
    I you the
    For each f in recordset1.fields
    structure to update one field at a time.
    and so update the current new record.
    there aren't a more elegant way?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
    Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now