Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Nathe, Khyle
  New Posts New Posts RSS Feed - Function IsInGroup Sample Database (IsInGroup.mdb)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

Function IsInGroup Sample Database (IsInGroup.mdb)

 Post Reply Post Reply
Khyle Nathe View Drop Down

Joined: 30 Jun 2008
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Khyle Nathe Quote  Post ReplyReply Direct Link To This Post Topic: Function IsInGroup Sample Database (IsInGroup.mdb)
    Posted: 10 Jul 2008 at 3:42am

This contains a simple function: Function IsInGroup, which can be used for determining which Group the CurrentUser belongs to. It has been posted in many forms on the Listservs, but I thought it would be a helpful example for others.

Usage Example - to make a button called "cmdAdmin" visible to the CurrentUser if they are a member of the Admins group, otherwise make it false - call in the OnOpen Event of a Form.

If IsInGroup(CurrentUser, "Admins") Then
    Me.cmdAdmin.Visible = True
    Me.cmdAdmin.Enabled = True
    Me.cmdAdmin.Visible = False
    Me.cmdAdmin.Enabled = False
End If

Download Access 97: uploads/30/


Email: (no longer valid. If you have any information, please contact Roger Carlson through this forum.)
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.