F
FGM
Is there a place to read more about the commands
needed in Access 2002 for using ADODB.Recordset etc.
What I used in Access 97 does not seem to work and I have
forgotten some. Need refresher. Books that I have do not
seem to be clear on commands?
Dim cnn1 as ADODB.Connection
Dim rstEmployees As ADODB.Recordset
Dim strCnn as String
Dim varDate as Variant
or
Dim dbsNorthwind as Database
Dim rstEmployees as Recordset
I am trying to read records from a table and update some
fields as each record is read if it meets the criteria.
Using loop until EOF.
What do I need once connected?
rstEmplyees!fname = "Bill"
rst.Update?
I have a few books mostly 97 & 2000 but can not seem to
find the answers that I need.
Any help would be appreciated or book that is good.
Thank you.
needed in Access 2002 for using ADODB.Recordset etc.
What I used in Access 97 does not seem to work and I have
forgotten some. Need refresher. Books that I have do not
seem to be clear on commands?
Dim cnn1 as ADODB.Connection
Dim rstEmployees As ADODB.Recordset
Dim strCnn as String
Dim varDate as Variant
or
Dim dbsNorthwind as Database
Dim rstEmployees as Recordset
I am trying to read records from a table and update some
fields as each record is read if it meets the criteria.
Using loop until EOF.
What do I need once connected?
rstEmplyees!fname = "Bill"
rst.Update?
I have a few books mostly 97 & 2000 but can not seem to
find the answers that I need.
Any help would be appreciated or book that is good.
Thank you.