T Tony Mar 10, 2004 #1 How I list columns in access, In ORACLE I use desc table what syntax I use in access to see all my columns in the table thanks
How I list columns in access, In ORACLE I use desc table what syntax I use in access to see all my columns in the table thanks
M MGFoster Mar 10, 2004 #2 Tony said: How I list columns in access, In ORACLE I use desc table what syntax I use in access to see all my columns in the table Click to expand... -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Try: Function testme() Dim f As DAO.field Dim db As DAO.Database Set db = CurrentDb For Each f In db.TableDefs("Table Name").Fields Debug.Print f.Name Next End Function Substitute your table's name for "Table Name." MGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) -----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv iQA/AwUBQE+IM4echKqOuFEgEQIgOQCfTVJt5uvigdLtvoi+Pe6AsQgXTUwAnRba hosYpxqK+0AP/g4eSAKMOZDB =YYM7 -----END PGP SIGNATURE-----
Tony said: How I list columns in access, In ORACLE I use desc table what syntax I use in access to see all my columns in the table Click to expand... -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Try: Function testme() Dim f As DAO.field Dim db As DAO.Database Set db = CurrentDb For Each f In db.TableDefs("Table Name").Fields Debug.Print f.Name Next End Function Substitute your table's name for "Table Name." MGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) -----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv iQA/AwUBQE+IM4echKqOuFEgEQIgOQCfTVJt5uvigdLtvoi+Pe6AsQgXTUwAnRba hosYpxqK+0AP/g4eSAKMOZDB =YYM7 -----END PGP SIGNATURE-----
