技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 700
|
10#
樓主 |
發(fā)表于 2012-9-27 11:38:19
|
只看該作者
Henry D. Sy 發(fā)表于 2012-9-26 14:11
??
Option Compare Database
Private b
Private Sub 堆頭陳列商品_Change()
Dim a As String
a = "*" & Me.堆頭陳列商品.Text & "*"
Me.堆頭陳列商品.RowSource = "SELECT 商品ID, 貨品編號(hào) FROM 商品目錄 Where 貨品編號(hào) like '" & a & "';"
Me.堆頭陳列商品.Dropdown
b = Me.堆頭陳列商品.Column(0, 0)
End Sub
Private Sub 堆頭陳列商品_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyUp, vbKeyDown
Me.堆頭陳列商品.OnChange = ""
Case Else
Me.堆頭陳列商品.OnChange = "[Event Procedure]"
End Select
End Sub
Private Sub 堆頭陳列商品_NotInList(NewData As String, Response As Integer)
Dim ctl As Control
Set ctl = Me!堆頭陳列商品
Response = acDataErrContinue
ctl.Undo
Me.堆頭陳列商品 = b
Me.堆頭陳列商品.RowSource = "SELECT 商品ID, 貨品編號(hào) FROM 商品目錄;"
SendKeys ("{Tab}")
End Sub
這是我從網(wǎng)上找到組合框模糊查詢例子的代碼,但這是只有一列字段的,像我的這個(gè)多列的字段怎么寫 |
|