E
EagleOne
2003
The built in Database documenter provides printable data, but seemingly, not easy to summarize or
analyze.
What I would like is: one table with a list of all Tables in a particular .mdb listed down in the
"Row" first column.
In the remaining "Columns" horizontally the field-names active for each Table Name. -or- better yet
The field-names would have a "flag" for each field active in that table.
For example:
ClientNumb Name Address Street State Phone Product ShipInfo TxnNum
Table 1 * * * * * * Table 2
* * *
Table 3 * * *
In short, I would like to filter for all tables containing the field TxnNum.
Sure I can get this information by manually copy/paste each tables' "documenter" information.
Is there a smarter easier way to get that information recapped?
Would anyone be willing to share a VBA routine previously developed?
TIA EagleOne
The built in Database documenter provides printable data, but seemingly, not easy to summarize or
analyze.
What I would like is: one table with a list of all Tables in a particular .mdb listed down in the
"Row" first column.
In the remaining "Columns" horizontally the field-names active for each Table Name. -or- better yet
The field-names would have a "flag" for each field active in that table.
For example:
ClientNumb Name Address Street State Phone Product ShipInfo TxnNum
Table 1 * * * * * * Table 2
* * *
Table 3 * * *
In short, I would like to filter for all tables containing the field TxnNum.
Sure I can get this information by manually copy/paste each tables' "documenter" information.
Is there a smarter easier way to get that information recapped?
Would anyone be willing to share a VBA routine previously developed?
TIA EagleOne