[RESOLVED] MSFlexGrid.AddItem

[varunj]

Hi all

I am working on msflexgrid, now i am stuck in one place, actually I want add row in flexgrid at run time...

I am using this syntex:

msFlxPane.AddItem "1" & vbTab & var_awb, msFlxPane.RowSel

now the problem is this, this statement add row but at begining of flexgrid, while I want add row at the last, is there any way to sort this problem

thanks in advance.

Regards
VJ

[d3gerald]

you can do something like this

msFlex.Rows = msFlex.Rows + 1
msFlex.TextMatrix(msFlex.Rows - 1, 0) = "First Collumn Value"
msFlex.TextMatrix(msFlex.Rows - 1, 1) = "Second Collumn Value"
msFlex.TextMatrix(msFlex.Rows - 1, 2) = "Third Collumn Value"
'and so on and so forth

[varunj]

Hi

thanks for your quick reply, but I did one thing, now I am sorting records after clicking on the grid

the code:

Private Sub msFlxPane_Click()
msFlxPane.Sort = 1
End Sub

this code is in one function which I call in another process:

msFlxPane.AddItem sno & vbTab & var_awb, msFlxPane.RowSel
Call msFlxPane_Click

every time sno(serial number will increase) and it will sort,

but still one problem is: in the top after fixed row it left one blank row..
I couldn't find why is this happening.

thanks in advance
Regards
VJ

[bushmobile]

you need to ensure you don't have any blank non-fixed rows in your grid before you start adding.

[varunj]

Hi bush

Yes I did that,

actually first I mention

msflexgrid.cols=8
msflexgrid.rows =2

when I got this problem, I did rows = 1
after that it gives run time error bcoz it takes first row for adding new row, and error says can not change fixed row..

now tell me..

regards
VJ

[bushmobile]

since you're sorting it anyway, you can remove the last argument of the .AddItem method:

msFlxPane.AddItem sno & vbTab & var_awb
Call msFlxPane_Click

[varunj]

Hi all

thanks for your valuable suggestions, I just solved the issue
I did one thing for that blank row I just mention one line

msFlxPane.RowHeight(1) = 0

and problem solved

thanks for all
Regards
Varun