baseballgem
Programmer
What is oField.Type for Date Type when creating a table programatically from outside Access?
Externally I've done a createobject("Access.Application") and I've made a table in a database. Evidently my date column is of type character - I have to make it a date.
It was created as Character because
I have statements like
oField = oTable.CreateField("LNAME")
oField.TYPE = 10 && Character Field
oField = oTable.CreateField("DATE")
oField.TYPE = ?? && Date Field
What number would be a date?
Externally I've done a createobject("Access.Application") and I've made a table in a database. Evidently my date column is of type character - I have to make it a date.
It was created as Character because
I have statements like
oField = oTable.CreateField("LNAME")
oField.TYPE = 10 && Character Field
oField = oTable.CreateField("DATE")
oField.TYPE = ?? && Date Field
What number would be a date?