Query for Table Field Names then Pass to Variables

[KevinTekTip]

I am making an Access form that lets the user create the tables, forms, and queries. I have successfully used command buttons and textboxes that run SQL statements to create tables, set the field definitions, and design the forms. To do most of this I use the Visual Basic code:

DoCmd.RunSQL "[SQL STATMENT GOES HERE]"

However, what I can't figure out is how to make the queries. I need to figure out a SQL query (lets call it "qryTableFieldNames") that will retrieve all of the table field names within a recently created table (lets call it "tblNewTable") and then let me pass those values into a variable.

Does anybody know a SQL statement that retrieves the field names?

I need to create a query based on a table that does not yet exist. Other words, at the same time that the new table is created from using my forms, text boxes, and DoCmd.RunSQL, I want a query to get built simultaneously hat includes the new field names.

Thanks for the help.

 

[lupins46]

I don't believe that you can get the field names as an SQL result. I think you would have to open the tabledef and cycle through the fields collection.

Can't you simply use:
Select * from tablename