How can i display all culumn names of a table by a query?

[mummyman]

How can i display all culumn names of a table by a query?, pls help me

 

[KenHigg]

You should be able to see these in the MYsyQueries table which is visible when you do Tools->Options->View->System Objects True.

kh

 

[Brianwarnock]

I don't know what mummyman is trying to do but if it is merely to obtain a list of field names without the info that comes with the documenter then a blank columnar report of the whole table is a simple way to achieve this.

Brian

 

[mummyman]

Here's what i need

I'm programming for a subject of asp and access.

I'm looking for a special SQL statement. When i execute that SQL statement, it return a list of all columns' name of a table.

Something like this :

"Select all_culumn_name from table_name"

Can you help me?

 

[Chatbox]

I'd like to know this as well.
Is there anyway to get the columns/fields header/name via VBA when given a table name? Or maybe some way to return the number of fields/columns there are in a given table....

 

[mummyman]

Aaaa

No one can help me?