Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is oField.Type for Date Type?

Status
Not open for further replies.

baseballgem

Programmer
Oct 3, 2001
54
0
0
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top