Results 1 to 9 of 9

Thread: Save into BD

  1. #1

    Thread Starter
    Addicted Member Appaq's Avatar
    Join Date
    Jul 2002
    Location
    Buzau | RO
    Posts
    179

    Save into BD

    how can i save the entry form a textbox to a database file!? please help me with this problem. I have one form where i put a name and i want that name for eg. Jhon Mitch to be registred to a data base file test.bd . (Acces file).

    Please help me whi this!
    skin

  2. #2
    Lively Member
    Join Date
    Mar 2002
    Location
    Klamath Falls, OR
    Posts
    71
    I'd recommend going to the vbworld site and checking out karl moore's DB tutorials:

    http://216.26.168.92/vbworld/article.aspx?tag=databases).
    (08/04/02)

    They are very easy to understand, you should be able to get through all of them (6 or 7 I think) in an hour or 2. There is WAY too much involved to contain a good answer in one post.

  3. #3
    Software Eng. Megatron's Avatar
    Join Date
    Mar 1999
    Location
    Canada
    Posts
    11,286
    Are you using ADO? Or DAO?

  4. #4
    Software Eng. Megatron's Avatar
    Join Date
    Mar 1999
    Location
    Canada
    Posts
    11,286
    Attached to this message is a small ADO tutorial, written by Beacan.
    Attached Files Attached Files

  5. #5

    Thread Starter
    Addicted Member Appaq's Avatar
    Join Date
    Jul 2002
    Location
    Buzau | RO
    Posts
    179
    thanks man! i will read this and i hope to find my answer
    skin

  6. #6

    Thread Starter
    Addicted Member Appaq's Avatar
    Join Date
    Jul 2002
    Location
    Buzau | RO
    Posts
    179
    Ups..

    this example works only with Microsoft Active Data Objects 2.5 and i have VB 6 with Microsoft ADO Data Control 6.0

    where i can find the right solution?!
    skin

  7. #7
    Addicted Member kidlaley's Avatar
    Join Date
    Jun 2002
    Location
    California
    Posts
    159

    if you are using ADO then..

    try this

    Code:
    Set rs = New Recordset
        rs.Open "tablename", connection, _
           adOpenStatic, adLockOptimistic, adCmdTable
        
        rs.AddNew
        rs.Fields("The Fields Name") = "What ever value"
        rs.Update
        rs.Close
        Set rs = Nothing
    There's only Three kinds of people in this world.....
    Those that know how to count, and those that do not......
    ]

  8. #8

    Thread Starter
    Addicted Member Appaq's Avatar
    Join Date
    Jul 2002
    Location
    Buzau | RO
    Posts
    179
    i think i find it here my asnwer

    http://www.vbsquare.com/databases/learndb/



    Thanks man! Maybe i will use your sample too
    skin

  9. #9

    Thread Starter
    Addicted Member Appaq's Avatar
    Join Date
    Jul 2002
    Location
    Buzau | RO
    Posts
    179

    Unhappy How ?!?!

    see here the image: www15.brinkster.com/appaq/db.gif

    This is all i wanna do! Just to read an exitent DB file and to write into that. (i am a beginer of ADO) I have "Microsoft ADO Data Control 6". Where i can find at less the information or documentation about this. Please help me. Post here a simple code. Thnaks!
    skin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width