I can't Click my MSHFlexGrid...

mac_ware23 · January 24th, 2005, 01:02 AM

This is my function to Highlight my grid

Public Function HighLightRow(grd As MSHFlexGrid)
    grd.RowSel = grd.Row
    grd.Col = 0
    grd.ColSel = grd.Cols - 1
End Function

but right after I execute this command, the problem started. I can't click on my Grid. I'm having trouble selecting the rows. Anybody could help me??? By the way I put all this function in Class.

Public Function Supervisor_Search(Grid As MSHFlexGrid, Field As String, KeyWord As String)

    SQL = "select * from tblSupervisor where " & Field & " like '" & KeyWord & "%' order by Supervisor_Lastname"
    rs.Open SQL, conn
    Set Grid.DataSource = rs
    rs.Close

End Function

gbianchi · January 24th, 2005, 09:33 AM

hi there...

since you pass a rs to your grid, and then you close it, it's closed to the grid too...

you have to maintain it open to make your grid still work...

HTH

Gonzalo

zaheer131 · March 15th, 2005, 03:47 AM

Quote:

quote:Originally posted by mac_ware23
This is my function to Highlight my grid

Public Function HighLightRow(grd As MSHFlexGrid)
    grd.RowSel = grd.Row
    grd.Col = 0
    grd.ColSel = grd.Cols - 1
End Function

but right after I execute this command, the problem started. I can't click on my Grid. I'm having trouble selecting the rows. Anybody could help me??? By the way I put all this function in Class.

Public Function Supervisor_Search(Grid As MSHFlexGrid, Field As String, KeyWord As String)

    SQL = "select * from tblSupervisor where " & Field & " like '" & KeyWord & "%' order by Supervisor_Lastname"
    rs.Open SQL, conn
    Set Grid.DataSource = rs
    rs.Close

End Function

zaheer131 · March 15th, 2005, 03:50 AM

Quote:

quote:Originally posted by mac_ware23
This is my function to Highlight my grid

Public Function HighLightRow(grd As MSHFlexGrid)
    grd.RowSel = grd.Row
    grd.Col = 0
    grd.ColSel = grd.Cols - 1
End Function

but right after I execute this command, the problem started. I can't click on my Grid. I'm having trouble selecting the rows. Anybody could help me??? By the way I put all this function in Class.

Public Function Supervisor_Search(Grid As MSHFlexGrid, Field As String, KeyWord As String)

    SQL = "select * from tblSupervisor where " & Field & " like '" & KeyWord & "%' order by Supervisor_Lastname"
    rs.Open SQL, conn
    Set Grid.DataSource = rs
    rs.Close

End Function

for this purpose dont use this function
just do this in the properties panel
property named as "selectionmode" just click on it n select selection by row
n if u wana to select the first colum as well so add another column in the grid n make its widht zero so it become invisible n grid selection look like from the first coloumn :)