如下代码,运行时提示错误,数据类型不匹配
Dim dbName As Database
Dim tdName As TableDef
Dim fdName As Field
Set dbName = OpenDatabase(App.Path & "\mdb\Smr.mdb")
Set tdName = dbName.CreateTableDef(tableName)
For i = 0 To 1
If byout(i * 5 + 2) = "1" Then
Set fdName = tdName.CreateField(byout(i + 1), dbText, 10)
tdName.Fields.Append fdName
End If
Next i dbName.TableDefs.Append tdName
CreateField()中的三个参数为字符串变量将如何设定。
Dim dbName As Database
Dim tdName As TableDef
Dim fdName As Field
Set dbName = OpenDatabase(App.Path & "\mdb\Smr.mdb")
Set tdName = dbName.CreateTableDef(tableName)
For i = 0 To 1
If byout(i * 5 + 2) = "1" Then
Set fdName = tdName.CreateField(byout(i + 1), dbText, 10)
tdName.Fields.Append fdName
End If
Next i dbName.TableDefs.Append tdName
CreateField()中的三个参数为字符串变量将如何设定。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货