userfriendly
Technical User
I need a module that creates a report to give me a description (the description seen in the design view of a table) of each field in each of my tables... can you help?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
module help
- Thread starter userfriendly
- Start date
- Status
Hi
Do you need it simply to document your design, if yes, then there is a Tools \ Analyze \ Document option which may do what you want.
If you want the column names to use in your Application, then you can get at them either via :
the Tabdef Object (by looping through the .fields collection eg tdf.fields(i).name
if you just want to display them in a combo box, then set the RowSourceType to Field List and the RowSource to the table name.
Regards
Ken Reay
Freelance Developer
kenneth.reay@talk21.com
Do you need it simply to document your design, if yes, then there is a Tools \ Analyze \ Document option which may do what you want.
If you want the column names to use in your Application, then you can get at them either via :
the Tabdef Object (by looping through the .fields collection eg tdf.fields(i).name
if you just want to display them in a combo box, then set the RowSourceType to Field List and the RowSource to the table name.
Regards
Ken Reay
Freelance Developer
kenneth.reay@talk21.com
- Status
Similar threads
- Question
- Locked
- Question
