:) 类型不符 dim rs as new adodb.recordset dim strSql as stringstrSql="select * from Sale_House where Address_House like '" & Text1.Text & " '" set rs=cn.execute(rs) 'cn为一个已经打开的数据库联接set adodc1.recordsource=rs
Set cn = OpenDatabase(App.Path + "\database\Fdc_DB.mdb")这样也不行的set rs=cn.execute(rs) 是不是错了,要改为set rs=cn.execute(strSql) 对吧
dim rs as new adodb.recordset
dim strSql as stringstrSql="select * from Sale_House where Address_House like '" & Text1.Text & " '"
set rs=cn.execute(rs) 'cn为一个已经打开的数据库联接set adodc1.recordsource=rs
就是说,在SQLServer中,模糊查询like 要用到“ % ”
而在Access中用" * "来做通配符。