select * from 表名 where 有记录=true order by 记录时间 这种类似?
绑定关联点击触发 比如SUB COMBO1.CLICK COMBO2.TEXT 跟着变 end sub
数据库表的结构是什么样的?Private Declare Function SendMessagebyString Lib _ "user32" Alias "SendMessageA" (ByVal hWND As Long, _ ByVal wMsg As Long, ByVal wParam As Long, _ ByVal lParam As String) As LongPrivate Const CB_FINDSTRINGEXACT = &H158 '在 ComboBox 中精确查找Private Sub Command1_Click() Set rs = cn.Execute("SELECT 寄存器编号 FROM 表名 WHERE 记录 = '" & Combo1.List(Combo1.ListIndex) & "' ORDER BY 记录时间 DESC")Combo2.Clear Do Until rs.EOF Combo2.AddItem rs!寄存器编号 LoopFor strReg = "a" To "d" If SendMessagebyString(Combo2.hWnd, CB_FINDSTRINGEXACT, -1, strReg) = -1 Then Combo2.AddItem strReg End If Next strReg End Sub
这种类似?
比如SUB COMBO1.CLICK
COMBO2.TEXT 跟着变
end sub
数据库表的结构是什么样的?Private Declare Function SendMessagebyString Lib _
"user32" Alias "SendMessageA" (ByVal hWND As Long, _
ByVal wMsg As Long, ByVal wParam As Long, _
ByVal lParam As String) As LongPrivate Const CB_FINDSTRINGEXACT = &H158 '在 ComboBox 中精确查找Private Sub Command1_Click()
Set rs = cn.Execute("SELECT 寄存器编号 FROM 表名 WHERE 记录 = '" & Combo1.List(Combo1.ListIndex) & "' ORDER BY 记录时间 DESC")Combo2.Clear
Do Until rs.EOF
Combo2.AddItem rs!寄存器编号
LoopFor strReg = "a" To "d"
If SendMessagebyString(Combo2.hWnd, CB_FINDSTRINGEXACT, -1, strReg) = -1 Then
Combo2.AddItem strReg
End If
Next strReg
End Sub