错误提示为:No value given for one or more required parameters.代码如下,如果代码还有其它错误,请多多指正,谢谢!!
Private Sub Command1_Click()
Dim strsql As String
Dim tmp_sql As String
Dim Conn As ADODB.Connection
Dim strAccess As String
strAccess = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\tiaomadata.mdb;User Id=admin;Password=;"
Set Conn = New Connection
Conn.Open strAccess
tmp_sql = " where id<>0 "
If Text1.Text <> "" Then
tmp_sql = tmp_sql & " and 名称 like '%" & Text1.Text & "%' "
End If
If Text2.Text <> "" Then
tmp_sql = tmp_sql & " and 条码 like '%" & Text1.Text & "%' "
End If
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
strsql = "select * from tm " & tmp_sql
rs.Open strsql, Conn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource = rs
Conn.Close
End Sub
Private Sub Command1_Click()
Dim strsql As String
Dim tmp_sql As String
Dim Conn As ADODB.Connection
Dim strAccess As String
strAccess = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\tiaomadata.mdb;User Id=admin;Password=;"
Set Conn = New Connection
Conn.Open strAccess
tmp_sql = " where id<>0 "
If Text1.Text <> "" Then
tmp_sql = tmp_sql & " and 名称 like '%" & Text1.Text & "%' "
End If
If Text2.Text <> "" Then
tmp_sql = tmp_sql & " and 条码 like '%" & Text1.Text & "%' "
End If
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
strsql = "select * from tm " & tmp_sql
rs.Open strsql, Conn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource = rs
Conn.Close
End Sub
解决方案 »
- vb6.0 ‘新建工程’对话框‘最新’文件夹内容的修改位置
- mschart连接sql数据库问题
- 紧急求助:请问在VB中怎样进行繁体字和简体字之间的相互转换?
- 怎么样创建动态控件数组?
- 请问网上哪里有制作ocx和dll控件的教程或源码?
- lihonggen0(李洪根,用.NET,标准答案来了) 快来领分!
- 如何在vb中删除一个字符串中的最后几个字符
- vb 超难问题:connection 利用msdatashape更新库,其errors属性大于0
- val(009)+val(001) 输出变成 00A 怎么做到呢?
- 如何将vb6中的工程文件,建成一个setup文件?
- 怎样可以从webbrowser里的链接,点击后把参数付给其他窗口的变量
- vb问题
tmp_sql = tmp_sql & " and 条码 like '%" & Text1.Text & "%' "
End If
-------------------------------
'%" & Text1.Text & "%' "Text1应该写成Text2吧?'%" & Text2.Text & "%' "
rs.Open strsql, Conn, adOpenStatic, adLockOptimistic
------------------------
需要设置客户端游标
rs.CursorLocation=adUseClient ' 设置客户端游标
rs.Open strsql, Conn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource = rs
Set rs = New ADODB.Recordset
strsql = "select * from tm " & tmp_sql
rs.CursorLocation = adUseClient
rs.Open strsql, Conn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource = rs
DataGrid1.Refresh数据肯定是有的,还是显示不出来,不知道为什么?
请各位高手多多指教