Change Password command

[Rob Parker]

I posted this in the access.formscoding group yesterday, but no reply there
yet, so I'll try here.

Using Access user-level security: I have a button on a form which opens the
User and Group Accounts dialog, via the following code:

DoCmd.RunCommand acCmdUserAndGroupAccounts

I also have a function which returns True if the current user is a member of
the admins group. What I would like to do is, if the user is not in the
admins group, to open the User and Group Accounts dialog with the Change
Password tab selected (since the Users tab doesn't have many usable options,
and what I really want is to allow users to change their password as easily
as possible).

(How) can I force the Change Password tab to be selected when the User and
Group Accounts dialog is opened?

TIA,

Rob

 

[TC]

Not to answer your question, but: In my opinion the standard security
interface is hard to understand. If you want your users to be able to
change their own passwords, why not just write a form for this? Have a
textbox for the old password, one for the new, and another to repeat
the new one. Then, in code attache to a "Change it now!" button, use
the NewPassword() method to actually make the change.

With that approach, you needn't display the standard security
interface, at all.

HTH,
TC [MVP Access]