Get fields name of table in fields collection

[FuzMic]

Hi guys

Another quick shot - i want to loop through all the fields in a table and list out the names.

So i am thinking of the field collection with all the Dim & Set and want a sure quick job done.

I think we can also do it with an recordset.

Will appreciate a quick comparison. Thanks in advance.

 

[Galaxiom]

One really easy way that displays the fieldnames in a Listbox is to use the FieldList setting of the listbox's RowSourceType. Put the name of the table (or query) in the RowSource.

 

[The_Doc_Man]

Essentially anything that behaves like a recordset will have a fields collection. If you have a form bound to a table (as opposed to a query) then Me.Recordset.Fields will work from that form to show you the fields in the table - but only for that one table that is bound.

 

[GinaWhipp]

You mean like this...
https://regina-whipp.com/blog/?p=1180

 

[FuzMic]

Thank you folks. I have just used the .fields associate with recordset.