MSHFlexGrid problem

I'm using MSHFlexgrid control to display data from SQLServer
my problem is, I want user only can select one row only at the flexgrid
How to do this ? Thanks

 JavaBoy
JavaBoy060299Asked:
Who is Participating?
 
wsh2Connect With a Mentor Commented:
Oh.. thats different.. <smile>.

Private Sub MSFlexGrid1_SelChange()

   MSFlexGrid1.rowsel = MSFlexGrid1.row

End Sub

0
 
wsh2Commented:
<----- Code Begin ----->

Private Sub MSFlexGrid1_KeyPress(KeyAscii As Integer)
'  Enter your row number here
   If MSFlexGrid1.Row <> 1 _
   Then
      MsgBox ("You can only update row 1")
      KeyAscii = 0
   End If
End Sub

<----- Code End ----->

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
SelectionMode = 1 - flexSelectionByRow
AllowBigSelection = False
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
JavaBoy060299Author Commented:
Adjusted points from 25 to 50
0
 
JavaBoy060299Author Commented:
wsh2:
Maybe there is some misunderstanding
I don't want user to select more than 1 row (not row 1), so user only allowed to block not more than one row

angelIII:
Have you try it ?
I have tried before I post this Q
but nothing happened

 
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
i admin, i didn't try the settings, as they seemed evident...

On the other hand, you say you don't want to have more that one row selected, what is if you consider only the Current Row as selected (for recordsets you have only one active row too)
0
 
JavaBoy060299Author Commented:
angelIII,

I know that, but I need some solution as wsh2 provides. thanks

wsh2,
Thanks for your answer !
It's exactly I'm looking for

 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.