Hi,

Thank for your advise, there is one more issue on datagrid.
Whenever I randomly click it, it might resize itself. I tried
to set all the individual column size in most of the resize event,
it seem happen, what am I missing, please kindly advise me.



>>Thank for your advise, therefore, is there any way to let it trigger
>>the events if I code manipulating the recordset programmtically ?
>
>When you delete a row, you can call your self the afterdelete event (just like any other proc). VB won't do it for you.
>
>
>>In addition, why is some of row highlighted ? How can I control
>>it so that only those bookmark row is highlighted as sometimes,
>>the highlighted is gone or all row is hightlighted.
>
>If you implemented codes from the articles belows, that's why you have row highligthed. Simply remove it.
>
>
>>
>>
>>
>>>Events of the grid are not triggered if you interact with the recordset directly.
>>>>Hi,
>>>>
>>>>Thank for your advise, I had already gone through the knowledge base articles before hand and already using the SP5. I finally mangaged to get it right.
>>>>
>>>>BTW, how come when I programmtically delete the record, the afterdelete event
>>>>never trigger ? as I need to keep track of the bookmark
>>>>
>>>>>Do you have the latest SP installed?
>>>>>
>>>>>See these:
>>>>>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195840
>>>>>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195472
>>>>>
>>>>>BTW, clicking on the second row should return you 1 since the rows are 0 based!
>>>>>
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>My VB6 application form is using MS datagrid where it is populated with data,
>>>>>>so whenever my user select/click any of the row, I want to bookmark it so that
>>>>>>I can do some manipulation to it, but I can't get it to work.
>>>>>>
>>>>>>On clicking the row, my bookmark is still remaining at the old value
>>>>>>until I click it again to get the current select row. Below is my code example
>>>>>>that will display the value 2 when I select the second row, but on selecting
>>>>>>back the first row, it will not trigger.
>>>>>>
>>>>>>Private Sub DataGrid_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
>>>>>>
>>>>>> msgbox "The row = " & datagrid.Row
>>>>>>
>>>>>>End Sub
>>>>>>
>>>>>>I also had tried to keep track of the current row by using the code below too, but
>>>>>>it didn't work for me, it keep giving me the old value until I reclick it gain.
>>>>>>
>>>>>>Private Sub DataGrid_SelChange(Cancel As Integer)
>>>>>>
>>>>>> msgbox "The row = " & datagrid.Row
>>>>>>
>>>>>>End Sub
>>>>>>
>>>>>>Please kindly advise me how to solve this problem of letting my user
>>>>>>to click the row, where I will bookmark it for retrieve later.
>>>>>>
>>>>>>Thank you