'登录时将登录权限ID赋给全局变量intPurviewId,权限ID数字越大权限越高。
Public intPurviewId As Integer
Public Function GetPurview(Allowpurview As Integer) As Boolean
If intPurviewId >= Allowpurview Then
GetPurview = True
Else
GetPurview = False
End If
End Function
'使用示例
Sub OpenForm()
If GetPurview(3) Then
DoCmd.OpenForm "frmMain"
Else
Exit Sub
End If
End Sub