Terri Hdokins
Registered User.
- Local time
- Today, 11:31
- Joined
- Jun 21, 2001
- Messages
- 15
I finally figured out how to delete a table and then create a new one. I am now stuck with not being able to add any more columns. My formula doesn't want to allow me to add any fields with the value as DATETIME.
I would greatly appreciate any suggestions. As you can tell I am very new to programming.
Thanks,
Terri Hodkins
On Error GoTo cmdDetailActual_Err
Dim strSQL As String
DoCmd.Echo True, ""
DoCmd.DeleteObject acTable, "tblDetailActual"
strSQL = "CREATE TABLE tblDetailActual" & "(LotNumber TEXT(10),Commodity TEXT(100),RanchPlot TEXT(100),Invoice LONG,TotalAmount CURRENCY)"
DoCmd.RunSQL strSQL
Exit Sub
I would greatly appreciate any suggestions. As you can tell I am very new to programming.
Thanks,
Terri Hodkins
On Error GoTo cmdDetailActual_Err
Dim strSQL As String
DoCmd.Echo True, ""
DoCmd.DeleteObject acTable, "tblDetailActual"
strSQL = "CREATE TABLE tblDetailActual" & "(LotNumber TEXT(10),Commodity TEXT(100),RanchPlot TEXT(100),Invoice LONG,TotalAmount CURRENCY)"
DoCmd.RunSQL strSQL
Exit Sub