List only specifc users

[Jeff Conrad]

Hi, me again.

Using Access 97.

I have the ADH 97 book with lots of security code samples,
but I need something somewhat customized.

How can I populate a combo box with a list of users from
one group, but excluding one specific user?

For example, I have a group called "Application Admins".
When I ship the MDW I will have one pre-defined saved user
called something like "ProgramAdmin." I don't want to have
this user's information be changed at all so I need to
have them hidden from my custom security set-up forms.

So I need the combo box to display only users in the
Application Admins group EXCEPT "ProgramAdmin." Is this
possible??

Better still :-) , can I populate a combo box with ALL
users of my "Application Users" group and ALL users of
my "Application Admins" group EXCEPT "ProgramAdmin"?

Any help would be greatly appreciated.
Jeff Conrad
Bend, Oregon

[Jeff Conrad]

Well I was able to figure this out.

In the ADH 97 book there is a function called
adhcboUsersFill.

I don't think I can legally post the whole code, but there
is one line that has this:

If strName <> "Engine" And strName <> "Creator" Then

Well I just added a few more things to the list like this:

If strName <> "Engine" And strName <> "Creator" And
strName <> "MyUserName" And strName <> "ProgramAdmin" And
strName <> "Admin" Then

Works like a charm!
Jeff Conrad
Bend, Oregon