Dim StrFilter As String
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text) & " ='" & Trim(Text1.Text) & "'"
End If
Adodc1.RecordSource = "select * from tips where " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False总是出现from子句有问题请问这个是什么问题
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text) & " ='" & Trim(Text1.Text) & "'"
End If
Adodc1.RecordSource = "select * from tips where " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False总是出现from子句有问题请问这个是什么问题
Dim StrFilter As String
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = Trim(Combo1.Text) & " ='" & Trim(Text1.Text) & "'"
End If
Adodc1.RecordSource = "select * from tips where " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = " where " & Trim(Combo1.Text) & " ='" & Trim(Text1.Text) & "'"
End If
Adodc1.RecordSource = "select * from tips " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = " where " & Trim(Combo1.Text) & " ='" & Trim(Text1.Text) & "'"
End If
Adodc1.RecordSource = "select * from tips " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
Dim StrFilter As String
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text) & " ='" & Trim(Text1.Text) & "'"
End If
Adodc1.RecordSource = "select * from tips where 1=1" & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
Dim StrFilter As String
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text) & " ='" & Trim(Text1.Text) & "'"
End If
Adodc1.RecordSource = "select * from tips where 1=1 " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text()) & " ='" & Trim(Text1.Text()) & "'"
End If
Adodc1.RecordSource = "select * from tips where " & StrFilter Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
发现了,!!COMBO1.TEXT(),TEXT1.TEXT()
Dim StrFilter As String
StrFilter = ""
'判断编号不为空 'If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text()) & " ='" & Trim(Text1.Text()) & "'"
End If
Adodc1.RecordSource = "select * from tips where " & StrFilter Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False 剪切都没剪切完,不知道今天怎么了??老出错!!
Dim StrFilter As String
StrFilter = ""
'判断编号不为空
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text()) & " ='" & Trim(Text1.Text()) & "'"
End If
Adodc1.RecordSource = "select * from tips where 1=1 " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
Dim StrFilter As String
StrFilter = ""
'判断编号不为空 '
If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text()) & " ='" & Trim(Text1.Text()) & "'"
End If
Adodc1.RecordSource = "select * from tips where 1=1 " & StrFilter
Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False 原来呢,用错了,用了SQL,汗!!
试试看对不对??
Dim StrFilter As String
StrFilter = ""
'判断编号不为空 'If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text()) & " ='" & Trim(Text1.Text()) & "'"
End If
Adodc1.RecordSource = "select * from tips where " & StrFilter Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False 55555555555555
Dim StrFilter As String
StrFilter = ""
'判断编号不为空 'If Len(Trim(Text1.Text)) > 0 Then
StrFilter = "" & Trim(Combo1.Text()) & " ='" & Trim(Text1.Text()) & "'"
End If
Adodc1.RecordSource = "select * from tips where " & StrFilter Adodc1.Refresh
DataGrid1.ReBind
DataGrid1.AllowAddNew = False
DataGrid1.AllowDelete = False
DataGrid1.AllowUpdate = False
狂顶了!!!5555555