Forms - Reading all records

[rathika]

hi

i need to process all the records from a table
programmatically. i meand using a loop and something like
do while not eof()
{
statments to process
skip to next record
}
i have done this in other languages. pls. help me how to
do this in ms access. should i use ADO or otherwise also
it is possible.

pls. help
rathika

 

[John Vinson]

hi

i need to process all the records from a table
programmatically. i meand using a loop and something like
do while not eof()
{
statments to process
skip to next record
}
i have done this in other languages. pls. help me how to
do this in ms access. should i use ADO or otherwise also
it is possible.

Depending on the process, there is almost certainly a way to do this
without looping in a Query.

It can be done in a Table by using a Recordset, either in DAO or ADO;
open a Recordset based on the table and use the MoveFirst and MoveNext
methods to loop through it. See the online help for Recordset.