Populating list boxes with the names of the fields of the tables 1

[jbranero]

Hi there, I am trying to populating list boxes with the names of the fields of the tables and I would like to make a SELECT in the Row Source property.
Does anybody have an idea about or another way to do it.
Thanks
j

 

[RoyVidar]

What application?

If it's Access, there are seven fora dedicated to Access, might try one of those for the next Access question? Getting field names in Access can't be done through SQL, as far as I know, but set the rowsourcetype of the list to field list, and the rowsource to the name of the table you wish to show the fields from...

Roy-Vidar

 

[SkipVought]

If you're using ADO or DAO, then the Field.Name property can be used like this...

...
set rst open .....

for each fld in rst.fields
  msgbox = fld.name
next

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[SkipVought]

oops....

no [equal] sign in a msgbox, is there.



Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[jbranero]

Great! it works perfectly.
Thanks a lot Mr. Roy.

 

[jbranero]

Also thanks to Skip! I think that in this case the suggestion from RoyVidal is easier.