Create List of Field Names

[DevDaniel]

I have: a table with many fields.

I want: to create a list of the field names in a new table.

Any suggestions?

 

[Arvin Meyer [MVP]]

If you import everything from this into your database, it wiil document all
the tables and field names in a table, and even print you out a nice report
with everything shown:

http://www.datastrat.com/Download/FieldDescription2K.zip

 

[Stefan Hoffmann]

hi Daniel,

I have: a table with many fields.
I want: to create a list of the field names in a new table.

If you only need to display them, e.g. in a ComboBox, then set its
property RowSourceType to "Field List".

http://msdn2.microsoft.com/en-us/library/aa831446(office.10).aspx


mfG
--> stefan <--

 

[DevDaniel]

Both suggestions were great! Thanks for your help!