代碼:
Public Declare Function SetActiveWindowa Lib "user32" Alias "SetActiveWindow" (ByVal hwnd As Long) As Long
事件中寫入
代碼:
SetActiveWindowa Application.hWndAccessApp
在本人實(shí)踐過程當(dāng)中Access在調(diào)用了置頂模塊的時(shí)候會(huì)導(dǎo)致Access原本能夠獲得焦點(diǎn)的控件丟失焦點(diǎn)
經(jīng)過大量實(shí)踐發(fā)現(xiàn)無論使用Access自身SetFocus還是API的APISetFocus都沒法讓Access重新獲得焦點(diǎn)
使用了API函數(shù)SetActiveWindowa函數(shù)后這個(gè)小bug就解決了
Public Declare Function SetActiveWindowa Lib "user32" Alias "SetActiveWindow" (ByVal hwnd As Long) As Long
事件中寫入
代碼:
SetActiveWindowa Application.hWndAccessApp
在本人實(shí)踐過程當(dāng)中Access在調(diào)用了置頂模塊的時(shí)候會(huì)導(dǎo)致Access原本能夠獲得焦點(diǎn)的控件丟失焦點(diǎn)
經(jīng)過大量實(shí)踐發(fā)現(xiàn)無論使用Access自身SetFocus還是API的APISetFocus都沒法讓Access重新獲得焦點(diǎn)
使用了API函數(shù)SetActiveWindowa函數(shù)后這個(gè)小bug就解決了

