Results 1 to 13 of 13

Thread: Update a RS using a flexgrid

Threaded View

  1. #1

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721

    Update a RS using a flexgrid

    Hi

    I have a form that contains a flexgrid and a cmd button which the
    user presses to update any changes...but I have a problem
    everytime I press the update cmd I receive an error (see JPG
    attached)

    The code I use is
    [Highlight=VB]
    Private Sub CmdUpdate_Click()
    UpdateFlexreview

    End Sub
    Private Sub UpdateFlexreview()
    Dim i As Integer
    Dim j As Integer

    With ObjRsFlex
    For i = 1 To MSFlexReview.Rows - 1
    .Fields("Event_Datetime").Value = i
    For j = 1 To MSFlexReview.Cols - 1
    .Fields("Column" & j).Value = MSFlexReview.TextMatrix(i, j)
    Next j
    .Update
    Next i
    End With

    End Sub
    [/vbode]

    Has anyone any suggestions... the error is displayed on the
    bolded line!!!!
    Attached Images Attached Images  
    ** HOLLY **

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