Results 1 to 2 of 2

Thread: help me!!

  1. #1
    Join Date
    Aug 2004
    Posts
    15

    Unanswered: help me!!

    i a using vb. i want to do a system as i attach to you the sample screens. when we click send button, all data are insert into the board history where user can't edit it. i don't know how to do it.
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2004
    Posts
    69
    considering your done declaring all necessary variables (connection, recordsets...etc.) after updating (which you would assign all the inputs to a table) ex. serial no is into rs!serial_no...then assign the datagrid's recordset to the active recordset in which you save your data. in this example, rs. Set the datagrid into "not" updatable for the user can't mess up your data. (i'll try to give a very simple example so even the noobs can understand.)

    Private Sub cmdSend_Click()
    rs.Addnew
    rs!serial_no = txtserialno.text
    rs!defect_mode = cmbdefect_mode.text
    rs!location = txtlocation.text
    rs!pin_no = txtpin_no.text
    rs!rework = cmbrework.text
    rs!icpn = txticpn.text
    rs!nlc = txtnlc.text
    rs.Update

    Set Datagrid1.Datasource = rs

    End Sub

    Hope you understand what i'm trying to tell....

Posting Permissions

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