EddyLLC

Using the following code I have a questions. .Fields(intFldCntr) = 2.66666666666667 yet after loading it into arrWhite(intIndex), arrWhite(intIndex) = 3. I'm working to get some weighted averages so I want the actual number. How can I prevent it from being rounded when I load it into the array? Thanks. Dim …

Hello all, working in VB6 I want to pull all records from Access table named Answers that in a field named Color have "White". Within that record there are 10 fields of various numbers that I want to sum and average. In short I want to pull all records with …

The following Code is causing an error when I try to set the AdoConn = New Connection. I receive an "Invalid Use of New Keyword" error. Can I get some guidence as to why? Thanks. [code]Dim adoRecordset As Recordset Private Sub Form_Load() Dim adoConn As Connection Set adoConn = New …

In the code below I use the Form_Load to connect to a Access database and load a form and combo box. I then use the cboComp_Click to look for a record in the tblToDo table, If found I load it into the form using the FillFields If not found I …

I'm using the following code behind a combo box name cboCompy. For some reason when I make a selection from the pulldown in the combo box this code won't fire. No errors appear but the code won't execute. I put stop in the code so I can view but it …