Loop Throw rows in datagrid

[prprogrammer]

I want to loop throw rows in datagrid...

 

[Golom]

Presumably "throw" should have been "through" ...

Your datagrid must have a recordsource ... probably a recordset. If so

if NOT rs.EOF then rs.MoveFirst
Do Until rs.EOF
    ' do Stuff
    rs.MoveNext
Loop

Where "rs" is the recordsource for your datagrid.

 

[prprogrammer]

That move through a recordset.....I want to move in datagrid..
row per Row....like in MSFlexGrid with textmatrix....etc

 

[bjd4jc]

Dim LCV As long
Dim str As string

For LCV = 1 to MSFlexGrid.Rows - 1 '0 is the headers
    str = MSFlexGrid.TextMatrix(LCV, 0) ' Or whatever column you wish to reference
Next