Forms - Reading all records

  • Thread starter Thread starter rathika
  • Start date Start date
R

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
 
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.
Click to expand...

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.
 
Back
Top