Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Print out of all the field names in an access database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-15 : 13:10:44
Marc writes "OK so I have the Access database and I want to just do a loop which prints out all the field names in a table.

For example if my database holds 20 different tables (e.g. customer, supplier, bank etc.) I would normally have to use each individual field name in my VB Script code (e.g. response.write customer_name, response.write customer_telephone, response.write customer_address etc. etc.) for every single table.

What I really want is to be able to just do a loop something like:
open table
loop while not end of table
print current field name
end loop

PLEAAAAAAAAAAAAAAASE TELL ME HOW?!??!?!?!?!?!?"
   

- Advertisement -