Field Name....Please Help

[anonymous]

[Originally posted by Martin Miller]

Hello there!ÿ You all have been a great help to me in the past, but I have another challenge for ya.ÿ Here it goes....ÿ In my VB app. I'm connecting to an access DB via ADO and I want to retrieve some field names (ex. NAME, CITY, etc.).ÿ How would I go about doing this.ÿ I thought maybe it was in the method "fields" but I can't find out how to do it. (ex: recordset.fields.item(0))ÿ Any help would be very much appreciated!ÿ Thanks in advance.

-Marty

[anonymous]

[Originally posted by Tim]

You can do a number of different ways. It depends on what you want to accomplish. To do it the way you are showing here you would want to do something like:
rs.fields(0).name

[anonymous]

[Originally posted by Martin Miller]

That did it! Thanks a lot.

Marty