Dan Waters
dwaters at usinternet.com
Sat Oct 14 08:13:42 CDT 2006
Hello to All! I'm having trouble with this function. It errors out on line 10, telling me 'Item not found in this collection'. It can find the Admins group??? It's as if the workspace is wrong or doesn't exist somehow. Dim wrk As DAO.Workspace Dim grp As DAO.Group Dim usr As DAO.User Dim varUserName As Variant Set wrk = DBEngine.Workspaces(0) wrk.Users.Refresh wrk.Groups.Refresh 10 Set grp = wrk.Groups("Admins") AdminGroupMember = False For Each usr In grp.Users If CurrentUser = usr.Name Then AdminGroupMember = True Exit For End If Next usr Exit Function Thanks for any and all help! Dan Waters