Querying Field Names

D

Dale Fye

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

Dan Artuso

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

Robert W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
QBF & Query Malfunction 0
determining if a field should be included 6
Incone & Expenses Statement 0
Setting Fieldname in query with a combobox 6
dynamic calculated field in query 3
Crating User Form to Add Names 1

Top