Private Sub Command3_Click()
Dim sql As String, mlink As String, mpath As String, mzy As String
mpath = App.Path
If Right(mpath, 1) <> "\" Then App.Path = mpath + "\"
mzy = InputBox$("请输入房号", "查找窗")
sql = "Select * from 散客帐务查询 where 房号='" & mzy & "'"
mlink = "Provider=Microsoft.Jet.OLEDB.3.51;"
mlink = mlink + "Persist Security Info=False;"
mlink = mlink + "Data Source=" + App.Path + "客人情况登记.mdb"
Adodc1.ConnectionString = mlink
Adodc1.CommandType = adCmdUnknown
Adodc1.RecordSource = sql
......................
阅读全部 | 2012年4月18日 13:35