Create List of Field Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DevDaniel - 29 Jun 2007 13:36 GMT

I have: a table with many fields.

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

Any suggestions?

Reply to this Message

Arvin Meyer [MVP] - 29 Jun 2007 14:22 GMT

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

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

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

Reply to this Message

Stefan Hoffmann - 29 Jun 2007 14:29 GMT

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 <--

Reply to this Message

DevDaniel - 26 Jul 2007 14:46 GMT

Both suggestions were great! Thanks for your help!

Reply to this Message