Search results for query: *

Thanks for the reply, but that doesn't work when formatting numbers in a grid where the DataSource is a table on a database. I'll check to see if my OLE DB Provider supports a format function, but I'd really like to understand how StdDataFormat works.

The easiest way to find the min and max values in your array is to step through all of them using a FOR loop. The code to set the upper and lower limits of the chart is: chtTimePen.Plot.Axis(VtChAxisIdY).ValueScale.Maximum = txtUpperLimit...

Or you could use a disconnected ADO recordset; I love these. You can create the ADO recordset using code such as this: Set rstAverages = New ADODB.Recordset With rstAverages .Fields.Append "SamplingPort", adTinyInt .Fields.Append "Average", adDouble...

I need to format a long decimal number (say 0.038375791) as a percentage with four decimal places (ie: 3.8375). I'm displaying the numbers in a MS DataGrid control that has a DataFormat property. As I understand it, if I use the standard "Percent" format it always displays two...

It looks like line 60 should read: CatQuery = "SELECT * FROM Names WHERE BallotNumber = " & VarBallotNumber & " AND BallotPage = " & VarBallotPage & " AND CatID = " & VarCategoryID I'm assuming that BallotNumber, BallotPage, and CatID are all numeric. If they are...