09-19-2000, 02:22 PM
In my data grid I want to change the data in the grid (grdSales) when data is changed in one of the cells. I have 5 columns: Date (doesn't change), Totsales (user inputs Value), ChargeTips (User inputs Value) SalesTax (calculated in program), and NetSales (calculated in program). I looked in the MSDN Library and some of the properties that it lists are not recognized like : Rows , CellValue and several others. What is wrong and how do I put data into the Cells I want
09-27-2000, 10:38 AM
You want to use the row, col and text properties. Here is a section of code from one of my programs.
If blnNOFDealer = False Then
If dbGrid.Visible = False Then
dbGrid.Visible = True
dbGrid.Row = intRow1
dbGrid.Col = 0
dbGrid.Text = intRow1
dbGrid.Col = 1
dbGrid.Text = .Fields("DealerId").Value
dbGrid.Col = 3
dbGrid.Text = .Fields("IntShipDate").Value
Sub_Get_PDS .Fields("DealerID").Value, intRow1
Sub_Get_SSS .Fields("DealerID").Value, intRow1
Sub_Get_STGY .Fields("DealerID").Value, intRow1
intRow1 = intRow1 - 1
09-27-2000, 12:55 PM
The help file is confusing no doubt. If you look very closely you will see that they state some of the properties belong to MSFlexGrid only. The appearance of the Flex is nicer that the DBGrid but lacks the editing ability of the DBGrid.
Quote of the moment....
"Ability has nothing to do with opportunity." - Napoleon Bonaparte