Navigate subset of records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to retrieve a subset of records in a specific order and I can do that
using SQL.

Having retrieved the records my problems start - I don't know the syntax to
navigate through the records and access the field values that I am after.

Any guidance, please
 
In
Graham said:
I need to retrieve a subset of records in a specific order and I can
do that using SQL.

Having retrieved the records my problems start - I don't know the
syntax to navigate through the records and access the field values
that I am after.

Any guidance, please
Click to expand...

Are you talking about opening a recordset on the query, and then
navigating within the recordset? That's pretty straightforward:

Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset( _
"SELECT * FROM MyTable WHERE SomeField = SomeValue")

With rs
Do Until .EOF
If !MyNumberField = 123 Then
' do something
End If
If !MyTextField = "Some Text" Then
' do something else
End If
.MoveNext
Loop
.Close
End With
 
Hi Dirk

Just started to do the implementation and the line
Dim rs As DAO.Recordset
gives a Compile error: User-defined type not defined.

I followed help on the error dialog which led me to the References dialog,
but I have no idea which entry should be checked so that the Dim will compile.

Using Access 2002.

Thanks
 
Graham said:
Hi Dirk

Just started to do the implementation and the line
Dim rs As DAO.Recordset
gives a Compile error: User-defined type not defined.

I followed help on the error dialog which led me to the References
dialog, but I have no idea which entry should be checked so that the
Dim will compile.

Using Access 2002.
Click to expand...

You need a reference to Microsoft DAO 3.6 Object Library.
 
Back
Top