Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

addnew method

ryanc2k3ryanc2k3 Member Posts: 28
can anyone show me an example of the addnew method(form.adodc1.recordset.addnew([fieldlist],[values]). really need your help! thank u:)

Comments

  • GideonOmegaGideonOmega Member Posts: 617
    : can anyone show me an example of the addnew method(form.adodc1.recordset.addnew([fieldlist],[values]). really need your help! thank u:)
    :


    with ado data controls this is a working method:
    (the db in question for the example has only one field "fldlastname",this could be applied to multiple fields)
    [code]
    With Adodc1.Recordset
    .AddNew
    !fldlastname = "Testing"
    .Update
    End With
    [/code]

    you would simply have more !fldnamehere = value, to add multiple fields

    Hope it helps
    [blue]
    C:Dos
    C:Dos Run
    Run Dos Run
    [/blue]

  • ryanc2k3ryanc2k3 Member Posts: 28
    : : can anyone show me an example of the addnew method(form.adodc1.recordset.addnew([fieldlist],[values]). really need your help! thank u:)
    : :
    :
    :
    : with ado data controls this is a working method:
    : (the db in question for the example has only one field "fldlastname",this could be applied to multiple fields)
    : [code]
    : With Adodc1.Recordset
    : .AddNew
    : !fldlastname = "Testing"
    : .Update
    : End With
    : [/code]
    :
    : you would simply have more !fldnamehere = value, to add multiple fields
    :
    : Hope it helps
    : [blue]
    : C:Dos
    : C:Dos Run
    : Run Dos Run
    : [/blue]
    :
    :
    hey thanx! ill try it:) ill just post another message if i encounter problems.
Sign In or Register to comment.