List Tables and Fields

User avatar
Abraxus
3StarLounger
Posts: 254
Joined: 01 Mar 2010, 17:34
Location: Blue Springs, MO

List Tables and Fields

Post by Abraxus »

Anyone have a quick & dirty way to enumerate through the tables and the fields in those tables?

For example:

For Each Table
For Each Field in Table
Debug.Print TableName - FieldName
Next
Next

Any help appreciated!
Morgan

User avatar
Abraxus
3StarLounger
Posts: 254
Joined: 01 Mar 2010, 17:34
Location: Blue Springs, MO

Re: List Tables and Fields

Post by Abraxus »

Guess I get to answer my own...for once!

Found some code at: http://www.tek-tips.com/faqs.cfm?fid=4310" onclick="window.open(this.href);return false;
Morgan

User avatar
HansV
Administrator
Posts: 78631
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: List Tables and Fields

Post by HansV »

Thanks for answering your own question (and posting the answer)! :grin:
Best wishes,
Hans