:eek: Flexgrid / access

[alex_read]

I would be very grateful for ANY assistance with the following, Thank you
everyone!


I have a flexgrid control, which shows 2 columns(which are taken from an Access 97 database table,showing a product, and the cost for the product).

The user can edit these (via a textbox & flexgrid cells), but I want them to be able to click onto a button and the changed data from the flexgrid to be changed within the access table (both columns by the way are from the same table in the access database).

I am trying to use something like the following I only have RS2 as only 1 of the columns [the cost] needs to be updated):

Dim x As Integer
x = 1

Do Until Rs2.EOF
Rs2.Edit
Rs2!Cost = FlxGrd.RowData(x)
x = x + 1
Rs2.Update
Rs2.MoveNext
Loop

With the above, I am trying to loop through each of the entries within the flexgrid column and place these in the database, only very badly.
The above does not work, however I change it. I am fairly new to the flexgrid, but going by DAO, I think my problem lies in :

a) telling VB to look / take the data to copy from the second column of the flexgrid (which I have not put above, as I am unsure of how to do this),
b)I think the "FlxGrd.RowData(x)" part is possibly a wrong way to go about this, I noticed you cannot have a "flexgrid!column2" type of code as you would with a recordset, could you tell me what to use here please?

Thank you for your help!
Alex Read

You can use the TextMatrix property, in it you can specify a Row and a Col property and then you get the value in the given field.

Debug.Print MSFlexGrid1.TextMatrix(iRow, iCol)

Where iRow would be the row you are looking for, and iCol would be 1(second colomn, flexgrid is 0 based).


Hope it helps.

[alex_read]

I cannot thank you enough for that!! I have been looking everywhere.

Thankyou!!!!!!!!!!!