Hi,

A novice problem. Please help if you can.

I have a very big mdb database. Let's say each record has a name field.
This name field is indexed but not UNIQUE. As the database is too big, I
can only rely on indexing to find records in this database but not
find(next/first) command.

The problem is I need to print out all records in the database with the
same name, say "GARFIELD", but cannot use findfirst(or next) to look the
whole database because it's too big and will take too long to find
records with the same name. So I have to use seek to get the record(s)
out. BUT, I always landed up getting the first record from the seek
command below.
        Table1.seek "=", "GARFIELD"

So after printing the first record with the name, "GARFIELD", how can I
print subsequent records with the name "GARFIELD" using the available
index file? In other words, is there an efficient method to look for all
records with the same name if I have a index file?

Please e-mail your reply

Thanks a million

--

Cheers,
Irene

---------------------------------------------------------

My Homepage :           http://www.*-*-*.com/ ~irene

:-))))))))) Have a nice day
---------------------------------------------------------

 In other words, is there an efficient method to look for all

You can find out how to use SQL in VB by searching on-line help for SQL,
and the RecordSource property of a data control.  Or see the "Guide to
Data Access Objects" in the Professional Features manual -- if you have
an hour to read, this explains everything.

Jennifer Bavar