求助各位大大
事情是这样的,在出错的窗体上我已经添加了ADODC1和DATAGRID设置如下:
adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\我的文档\db1.mdb;Persist Security Info=False"
adodc1的recordsource对应的是db1的design表
datagrid对应了adodc1我想通过点击command1实现查询,
Private Sub Command1_Click()
adodc1.RecordSource = "select * from Design where 客户 ='" & DataCombo1.Text & "' "
adodc1.Refresh //提示这里出的错 说 from子句出错 小弟不才,没看出错来 ,特来请教12 多谢
End Sub
事情是这样的,在出错的窗体上我已经添加了ADODC1和DATAGRID设置如下:
adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\我的文档\db1.mdb;Persist Security Info=False"
adodc1的recordsource对应的是db1的design表
datagrid对应了adodc1我想通过点击command1实现查询,
Private Sub Command1_Click()
adodc1.RecordSource = "select * from Design where 客户 ='" & DataCombo1.Text & "' "
adodc1.Refresh //提示这里出的错 说 from子句出错 小弟不才,没看出错来 ,特来请教12 多谢
End Sub
Private Sub Command1_Click()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\我的文档\db1.mdb;Persist Security Info=False"
Adodc1.RecordSource = "select * from Design where 客户 ='" & DataCombo1.Text & "' "
Adodc1.Refresh
End Sub
adodc1.RecordSource = "select * from [Design] where 客户 ='" & DataCombo1.Text & "' "