[VB6 ] 從Access中select
請問一下各位先進
小弟目前想要的功能是建一個textbox 裡面可填入搜尋的代號
就像第一段這樣
但是下面第一段是錯誤的,第二段才是正確的
請問一下各位該怎麼改呢?
感謝!
1:
strAddColumn = "SELECT * FROM table1 WHERE 代號='txtNum.Text'"
Set WorkBase = OpenDatabase("E:\a.mdb")
Set WorkRS1 = WorkBase.OpenRecordset(strAddColumn)
2:
strAddColumn = "SELECT * FROM table1 WHERE 代號='1111'"
Set WorkBase = OpenDatabase("E:\a.mdb")
Set WorkRS1 = WorkBase.OpenRecordset(strAddColumn)
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.113.91.122
推
09/16 23:04, , 1F
09/16 23:04, 1F
→
09/16 23:26, , 2F
09/16 23:26, 2F