关于ADO的重要问题!!!!???进来看来,有意思哟!!!
Dim cnn As New ADODB.Connection
ADO1.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data " & _ "Source=D:\SQL\" & L0收银员.Caption & ".mdb;Persist Security Info=False"
'联结以收银员编号的数据库.mdb
cnn.Open "Provider = Microsoft.Jet.OLEDB.4.0;Data " & _
"Source=D:\SQL\" & L0收银员.Caption & ".mdb;Persist Security Info=False"
Dim Ty As String
Ty$ = CDate(Date)
ADO1.RecordSource = Ty
ADO1.CommandType = adCmdText
cnn.Execute "insert into " & Ty & "(商品编号) values('a10000001')"
ADO1.CommandType = adCmdTable
ADO1.Refresh
以上代码中 cnn.Execute "insert into " & Ty & "(商品编号) values('a10000001')"的Ty出错;本人分析是因为Ty的值为****-**-**的字符串,在出错的这行代码中怎样改才能得到正确执行的结果!!!!
先谢过了!!!!??????