felicia
asked on
ADO Field Record Count...
Please can I have advised from the VB experts. Many Thanks!
I had a MS Access database with a 'updateRecord' field.
This 'updateRecord' field had a value of TRUE and FALSE.
How then can I do a count of knowing how many TRUE and FALSE records in the 'updateRecord' field.
Below is my coding...
Private Sub cmdUpdatPrice_Click()
'Read Microsoft Access Updating File
DiskFile = App.Path & "\sisTest3.mdb"
On Error GoTo DatabaseAccessError:
adosql.Refresh
adoaccess.Refresh
'adoaccess.Recordset.Recor dCount
Label1.Caption = adoaccess.Recordset.Record Count
Do While Not adoaccess.Recordset.EOF
adosql.Recordset.MoveFirst
adosql.Recordset.Find "ProductNo='" & adoaccess.Recordset.Fields ("ProductN o") & "'"
If Not adosql.Recordset.EOF Then
adosql.Recordset.Fields("u pdateRecor d") = True
adoaccess.Recordset.Fields ("updateRe cord") = True
adoaccess.Recordset.Update
adosql.Recordset.Update
adoTableName.RecordSource = "[" & adosql.Recordset.Fields("T ableName") & "]"
adoTableName.Refresh
adoTableName.Recordset.Fin d "ProductNo='" & adoaccess.Recordset.Fields ("ProductN o") & "'"
adoTableName.Recordset.Fie lds("Deale rPrice1") = adoaccess.Recordset.Fields ("DealerPr ice1")
adoTableName.Recordset.Fie lds("ListP rice1") = adoaccess.Recordset.Fields ("ListPric e1")
adoTableName.Recordset.Upd ate
Else
adoaccess.Recordset.Fields ("updateRe cord") = False
adoaccess.Recordset.Update
End If
adoaccess.Recordset.MoveNe xt
Loop
MsgBox ("Sis Price Updating Done. Click OK to exit to Price Updating Interface.")
ProcExit:
Call cmdQuit_Click
Exit Sub
DatabaseAccessError:
MsgBox ("Oops ! SiS Price Updating File cannot be found. Please make sure the 'SiS Price Updating Template' Microsoft Access Database is in the SiS server"), vbExclamation
Resume ProcExit
End Sub
I had a MS Access database with a 'updateRecord' field.
This 'updateRecord' field had a value of TRUE and FALSE.
How then can I do a count of knowing how many TRUE and FALSE records in the 'updateRecord' field.
Below is my coding...
Private Sub cmdUpdatPrice_Click()
'Read Microsoft Access Updating File
DiskFile = App.Path & "\sisTest3.mdb"
On Error GoTo DatabaseAccessError:
adosql.Refresh
adoaccess.Refresh
'adoaccess.Recordset.Recor
Label1.Caption = adoaccess.Recordset.Record
Do While Not adoaccess.Recordset.EOF
adosql.Recordset.MoveFirst
adosql.Recordset.Find "ProductNo='" & adoaccess.Recordset.Fields
If Not adosql.Recordset.EOF Then
adosql.Recordset.Fields("u
adoaccess.Recordset.Fields
adoaccess.Recordset.Update
adosql.Recordset.Update
adoTableName.RecordSource = "[" & adosql.Recordset.Fields("T
adoTableName.Refresh
adoTableName.Recordset.Fin
adoTableName.Recordset.Fie
adoTableName.Recordset.Fie
adoTableName.Recordset.Upd
Else
adoaccess.Recordset.Fields
adoaccess.Recordset.Update
End If
adoaccess.Recordset.MoveNe
Loop
MsgBox ("Sis Price Updating Done. Click OK to exit to Price Updating Interface.")
ProcExit:
Call cmdQuit_Click
Exit Sub
DatabaseAccessError:
MsgBox ("Oops ! SiS Price Updating File cannot be found. Please make sure the 'SiS Price Updating Template' Microsoft Access Database is in the SiS server"), vbExclamation
Resume ProcExit
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sooo....sorrie...i don't know why the systems did not give points...
I attached points with it...
:)
felicia
I attached points with it...
:)
felicia
Are the points deducted from your 'Available Points' ? If so: contact EE!
Otherwise, if you still want to give the point to me then make a dummy question (like "TO ROVERM"), wait for my response and then accept my response as an answer. But you don't HAVE to !
D'Mzzl!
RoverM
Otherwise, if you still want to give the point to me then make a dummy question (like "TO ROVERM"), wait for my response and then accept my response as an answer. But you don't HAVE to !
D'Mzzl!
RoverM
:-((
D'Mzzl!
RoverM