Results 1 to 37 of 37

Thread: current record set does not support upadating

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2006
    Posts
    84

    Unhappy current record set does not support upadating

    can anyone help me with this i'v been trying to fix this but i can't. ive already done the solutions posted in forums but still having error...
    the error is the .fields(0) = txtappid down... please help me... thank you in advance.

    VB Code:
    1. Private Sub Form_Load()
    2. tbInquiry.Open "Select * from tbinquiry", cn, adOpenKeyset, adLockOptimistic
    3. CallFields
    4. End Sub
    5. Private Sub LV1_Click()
    6. str = "Select * from tbinquiry where ApplicantID like '" & LV1.SelectedItem.Text & "'"
    7. Set tbInquiry = cn.Execute(str)
    8.  
    9. With tbInquiry
    10.     If .BOF = False And .EOF = False Then
    11.         txtFind = .Fields(3) & " " & .Fields(1) & ", " & .Fields(2)
    12.        
    13.     End If
    14. End With
    15. End Sub
    16.  
    17. Private Sub cmdSave_Click()
    18. Frame5.Visible = True
    19. Frame4.Visible = False
    20. txtSummary.Text = "(New Entry Saved. CLick Next To Proceed."
    21.  
    22. With tbInquiry
    23.             .Fields(0) = txtAppID
    24.     .Fields(1) = txtAppInfo(0)
    25.     .Fields(2) = txtAppInfo(1)
    26.     .Fields(3) = txtAppInfo(2)
    27.     .Fields(4) = txtAppInfo(3)
    28.     .Fields(5) = txtAppInfo(4)
    29.     .Fields(6) = cmbTFA.Text
    30.     '.Fields(7) =
    31.         'AddFields
    32.         .Update
    33.          MsgBox "Edit successfully saved to the record.", vbInformation
    34. End With
    35. End Sub
    36.  
    37. Private Sub Form_Load()
    38. str = "Select * from tbinquiry where ApplicantID like '" & frmApplicantDetails.lvList.SelectedItem.Text & "' "
    39. Set tbInquiry = cn.Execute(str)
    40.  
    41. With tbInquiry
    42.     If .BOF = False And .EOF = False Then
    43.         txtAppID = .Fields(0)
    44.         txtAppInfo(0) = .Fields(1)
    45.         txtAppInfo(1) = .Fields(2)
    46.         txtAppInfo(2) = .Fields(3)
    47.         txtAppInfo(3) = .Fields(4)
    48.         txtAppInfo(4) = .Fields(5)
    49.         cmbTFA.Text = .Fields(6)
    50.        
    51.     End If
    52. End With
    Last edited by si_the_geek; Feb 6th, 2007 at 11:39 AM. Reason: added vbcode tags

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