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!
List Tables and Fields
-
- 3StarLounger
- Posts: 254
- Joined: 01 Mar 2010, 17:34
- Location: Blue Springs, MO
List Tables and Fields
Morgan
-
- 3StarLounger
- Posts: 254
- Joined: 01 Mar 2010, 17:34
- Location: Blue Springs, MO
Re: List Tables and Fields
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;
Found some code at: http://www.tek-tips.com/faqs.cfm?fid=4310" onclick="window.open(this.href);return false;
Morgan
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: List Tables and Fields
Thanks for answering your own question (and posting the answer)!
Best wishes,
Hans
Hans