G Guest Jan 7, 2005 #1 Is there a way to list all the table names, and fields if possible, in a query? Thanks in advance, Wei
Is there a way to list all the table names, and fields if possible, in a query? Thanks in advance, Wei
A Allen Browne Jan 8, 2005 #2 You can get a list of the tables by looping through the TableDefs Collection. That approach also gives you the Fields collection, along with the Properties of each field. Example of listing the fields in a TableDef: http://members.iinet.net.au/~allenbrowne/func-06.html
You can get a list of the tables by looping through the TableDefs Collection. That approach also gives you the Fields collection, along with the Properties of each field. Example of listing the fields in a TableDef: http://members.iinet.net.au/~allenbrowne/func-06.html
