List Table Field Names only

J

js

I always forget what the sql is to list only the table
field name, not the data...

thanks
 
A

Andy

The only way I know of to accomplish this is to use VB to
interate through the table objects then the field
objects. I don't think this can be done in Access using
SQL.
 

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

Weekly Report 2
Insert name and adress from a list in a word document 1
Help creating a search form in Access XP 0
Unable to display values in 2nd list box from 1st list box selection 2
Mail Merge Directory Conditional Page Break 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Append Crosstab Query to Existing Table 0

Top