程序如下:
Public adocn As New ADODB.Connection
Public adors As New ADODB.Recordset
Public adocmd As New ADODB.Command
adocn.ConnectionString = "DSN=hys;DATABASE=hys"
adocn.Open
With adors
If .State = 1 Then .Close
Set adocmd.ActiveConnection = adocn
adocmd.CommandText = "Select * from djqsr where 生产日期 &_ between DTPicker1.Value and DTPicker2.Value
'DTPicker1和DTPicker2控件用于接受日期
.CursorLocation = adUseClient
.Open adocmd.CommandText, adocn, adOpenDynamic,&_ adLockBatchOptimistic, 2
End With
请高手赐教,请给出修改后的代码!定重谢!
Public adocn As New ADODB.Connection
Public adors As New ADODB.Recordset
Public adocmd As New ADODB.Command
adocn.ConnectionString = "DSN=hys;DATABASE=hys"
adocn.Open
With adors
If .State = 1 Then .Close
Set adocmd.ActiveConnection = adocn
adocmd.CommandText = "Select * from djqsr where 生产日期 &_ between DTPicker1.Value and DTPicker2.Value
'DTPicker1和DTPicker2控件用于接受日期
.CursorLocation = adUseClient
.Open adocmd.CommandText, adocn, adOpenDynamic,&_ adLockBatchOptimistic, 2
End With
请高手赐教,请给出修改后的代码!定重谢!
修改之后,问题依旧.提示:FROM 子句语法错误.
我用的是ACCESS,确认时间类型匹配后,问题依旧.
请大侠们赐教.
adocmd.CommandText = "Select * from djqsr where 生产日期 between '#"+ DTPicker1.Value + "#' and '#" + DTPicker2.Value +"#'"
采用第二种办法后,问题消失.
新问题出现,提示:数据类型不匹配
请SKYSYAN或者大侠们赐教!
adocmd.CommandText = "Select * from djqsr where 生产日期 between #"+ DTPicker1.Value + "# and #" + DTPicker2.Value +"#"
adocmd.CommandText = "Select * from djqsr where 生产日期 between #" & DTPicker1.Value & "# and #" & DTPicker2.Value & "#"