設置recordset時為什麼會出錯呢?

笨笨虫

  Dim Rst As Recordset
    Dim tmpDb As Database
    Set tmpDb = CurrentDb
    Set Rst = tmpDb.OpenRecordset("select * from PassWord where user='" & UserName & "';")

笨笨虫

有没人答我啊?

jhf567

[此贴子已经被作者于2003-11-28 20:54:44编辑过]

ADAM

試試這樣子
Dim Rst As DAO.Recordset
    Dim tmpDb As DAO.Database
    Set tmpDb = CurrentDb
    Set Rst = tmpDb.OpenRecordset("select * from PassWord where user='" & UserName & "';")

cxhgc

这个语句是干什么用的啊?
难道是打印的时候需要密码?