Querying Field Names

  • Thread starter Thread starter Robert W
  • Start date Start date
Not that I'm aware of. If you are using DAO, you can take a look at
the TableDefs object in Access help. If I remember correctly, it
shows how to create a tabledef object and loop thru all of the fields
to come up with all the names. If you wanted to do this on a regular
basis, I'd recommend writing a function that returns a recordset.

--
HTH

Dale Fye


Is it possible to create a query that brings up only a
tables fieldnames?
 
Hi,
No, but you can display field names in a combo or listbox.
Just set the row source type to Field List and then
select the table in the row source.
 
Thanks for the help.

Now I just need to figure out how to get the one combo box
that lists the tables to display its fields when you click
that item.
 
Back
Top