dim dbs as database
dim rst as recordsetset dbs=opendatabase("path",,";pwd=xxxx")
set rst=dbs.openrecordset("xx")set Data1.recordsource=rst
dim rst as recordsetset dbs=opendatabase("path",,";pwd=xxxx")
set rst=dbs.openrecordset("xx")set Data1.recordsource=rst
第一个运行到set Data1.recordsource=rst时,显示“属性的使用无效”
各位再帮帮忙吧?
dim dbs as database
dim rst as recordsetset dbs=dbengine.opendatabase("pathandname",,"ms access;pwd=xxxx")
set rst=dbs.openrecordset("xx")set Data1.recordsource=rst用第二种方法时,要确认databasename正确,因为更改connect后,会自动更改databasename
dim dbs as database
dim rst as recordsetset dbs=dbengine.opendatabase(yourmdbfile,false,false,"ms access;pwd=xxxx")
set rst=dbs.openrecordset("xx")set Data1.recordsource=rst用第二种方法时,要确认databasename正确,因为更改connect后,会自动更改databasename(只有路径,没有文件名),需要手工输入文件名
connect 应该为;pwd=xxxx
Data1.Connect = ";pwd=密码"
Data1.RecordSource = "表名"
Data1.Refresh
label1= Data1.Recordset.Fields("字段")
显示错误'91'
set data1.recordset=rst前面没看清,对不起。
这句代码好象很多地方不通啊!如果想让label1绑定data1,可能设计时将label1的DataSource属性设为data1,DataField属性设置为你想要显示的字段。这时你只能用第二种连接方法。如果是用第一种连接方法,请先在设计时将label1的DataSource属性设为data1,在代码中写label1.datafield="xxx"