Displaying All Records From A Database

[jeffreypadams]

I would like to know how you display all the records of a database rather than one at a time. Also, is is possible to display all the records but just one field. For example, say Name was the field and I wanted to display all the Names in the database table. Help!

P.S. I am using VB 5 and Microsoft Access 2000 and 97, however, I would like to export my tables in a Text File.

[simonm]

1)
Do you mean to display all records from a particular table at a time?

OR

Do you mean to display all records from all tables at one time?

2)
Display where? In a report, on a form (etc.)?

Further clarification required I think.