xizat
11-20-2000, 09:38 PM
Now there is a form with a msflexgrid(scrollbars),a Data and a timer. The msflexgrid has been binded with Data. The data will refresh each second using the timer. Then there is a question...
Because the data source has many data columns, the msflexgrid has a horizon scrollbar automatically. When I click the scroll bar, the data of the msflexgrid will scroll.But when the data refreshed, the scroll bar will go back to the beginning spot. I wonder if there is certain method can remember the current spot of the scroll and keep the msflexgrid consistent.
Please help me!
NoahBody
11-27-2000, 04:09 PM
Use the .Value property to remember where the scroll bar was.
->Noah
davy_sh
08-25-2003, 09:11 AM
Hello Noah, I saw ur answer to setting the value of the scrollbars to the position that one wanted. But how do I get the value for the scrollars in a MSFlexGrid???
When I give MSFlexgrid1.scrollbars.value = 500. I get a error saying Invalid qualifier. Please can u help?
Thanks
Davy
Use the .Value property to remember where the scroll bar was.
->Noah
zak2zak
08-25-2003, 12:03 PM
May be this helps...
Try to Store the Col & Row position in a variables
'In the procedure before update.
Dim intRow As Integer
Dim intCol As Integer
intRow = MSFlexGrid1.Row
intCol = MSFlexGrid1.Col
'Do the update statement.....
'..............
'After Completion of update and refreshing
MSFlexGrid1.TopRow = intRow
MSFlexGrid.LeftCol = intCol
This is just a suggestion it's up to U to decide........//
davy_sh
08-25-2003, 09:13 PM
The .Toprow worked just fine . Thank you!!!!!
Davy
May be this helps...
Try to Store the Col & Row position in a variables
'In the procedure before update.
Dim intRow As Integer
Dim intCol As Integer
intRow = MSFlexGrid1.Row
intCol = MSFlexGrid1.Col
'Do the update statement.....
'..............
'After Completion of update and refreshing
MSFlexGrid1.TopRow = intRow
MSFlexGrid.LeftCol = intCol
This is just a suggestion it's up to U to decide........//