获取窗体在记录跳转时触发了多少个事件( a1 D1 z: [$ p% V& i6 j
将下列代码复制到模块中,并按F5运行,然后打开“窗体1”,做一些动作即可。 _& c4 x% S' x0 A
Function setEvent()$ g% Y: s( v' Z) J& X+ B
Dim p As Property) r! O/ E2 b3 L, B3 j3 m7 m
For Each p In Forms("窗体1").Properties. z7 c3 A. {' T9 [( _
If Left(p.Name, 2) = "On" _
3 {) r. y3 m, v7 b& U f. r! | Or Left(p.Name, 5) = "After" _1 ? x& j9 h% D S4 V- |
Or Left(p.Name, 6) = "Before" Then: y" d ]& F, e# m
p.Value = "=msgbox('" & p.Name & "')"- {1 k5 [( z) n \ ~8 n) H
End If
; Q$ I; W1 l/ z* U& r Next p- x0 z) A1 x0 I; j+ X+ y
End Function
# t8 O$ _% p5 r/ t) z$ U3 I& o, } Function resumeEvent()
! J3 p0 z$ p. l! J+ w8 G1 S Dim p As Property$ Z; n/ {( u1 }$ ]2 ?; G( b8 g
For Each p In Forms("窗体1").Properties9 n6 h. S0 g# }$ @
If Left(p.Name, 2) = "On" _
" y& X9 y% Q0 s9 r* F% ^9 j" n Or Left(p.Name, 5) = "After" _
0 L- H' W- z' E Or Left(p.Name, 6) = "Before" Then
9 J+ H: k: B, k% b+ F8 D( B p.Value = ""
7 D& l9 U4 m4 k, C, w End If. _+ m& W( v" u
Next p# s6 w: m9 e9 q# S" q2 o( J$ i
End Function |