David McAfee
davidmcafee at gmail.com
Wed Nov 5 11:23:00 CST 2014
In Access (2003), How can I get the Field Type, for a given Table Def Field Type integer? I used the following code to populate a table with field names and types for given tables: Set db = OpenDatabase(Path & mdbName) Set td = db.TableDefs(TableName) '**************************************** For Each fld In td.Fields strSQL = "INSERT INTO tblFieldsInISRRE (FieldName, FieldType, FieldSize, JunctFKID) VALUES ('" & fld.Name & "', '" & fld.Type & "', " & fld.Size & ", " & JunctPKID & ")" DoCmd.SetWarnings False DoCmd.RunSQL (strSQL) DoCmd.SetWarnings (True) Next Now when I query the table, I get everything that I need except the field type (Number, text...) Instead I get 10,12,15,20,3,4,5,8 (and that is sorted ascending?!?!?) Is there a sys table that I can join to, or make my own? Thanks, D