S
Steve
I am trying to create a table thru VBA and set one of the fields to numeric
(decimal) with 3 places to the right of the decimal.
I would have thought the following would work but I get an error msg of
"Invalid field data type".
Set DBS = CurrentDB
Set MyTableDefs - DBS.CreateTableDef("TicketInfo")
With MyTableDefs
.Fields.Append .Createfield("Sort_Index", dbDecimal, 3)
End With
DBS.TableDefs.Append MyTableDefs
Can anyone shed some light on how to accomplish this?
(decimal) with 3 places to the right of the decimal.
I would have thought the following would work but I get an error msg of
"Invalid field data type".
Set DBS = CurrentDB
Set MyTableDefs - DBS.CreateTableDef("TicketInfo")
With MyTableDefs
.Fields.Append .Createfield("Sort_Index", dbDecimal, 3)
End With
DBS.TableDefs.Append MyTableDefs
Can anyone shed some light on how to accomplish this?