Does anyone have a form and VB code to allow users to change thei.

[Guest]

Thanks ahead of time!

 

[Rick B]

your entire text did not post. Change their what?

 

[Lynn Trapp]

To change their what?

 

[Keith Wilby]

To change their what?

I'm betting it's 'password' ;-p

 

[Lynn Trapp]

That's kind of what I figured to, but didn't want to speak for the poster.

 

[Keith Wilby]

That's kind of what I figured to, but didn't want to speak for the
poster.

Well it's nearly Xmas so I thought I'd let my hair down a bit )

 

[Immanuel Sibero]

hair down a bit )

We should all be so lucky.

 

[Guest]

r passwords. I'm sure somebody has done this and I'm not that great with VB
yet.
Thanks again.............Greg

 

[Lynn Trapp]

hair down a bit )

We should all be so lucky.

Does that mean what I think it does? ;-)

 

[Lynn Trapp]

The easiest way is to open the User Group Accounts dialog:

DoCmd.RunCommand acCmdUserAndGroupAccounts

 

[Guest]

Thanks Lynn for seeing my own reply to my original question. I was hoping
that someone that has done this with a form could send me the form and vb
script so I don't have to reinvent the wheel. Have you done this exercise
before?
Thanks........Greg

 

[Lynn Trapp]

You're welcome. I have used the command I sent you to do this. Just put it
behind a command button. It will open the User and Group Account dialog box.
No reinvention of the wheel at all.

 

[Keith Wilby]

We should all be so lucky.

This group isn't just for the folliclly challenged is it? ;-p

 

[Lynn Trapp]

This group isn't just for the folliclly challenged is it? ;-p

I sure hope not.

 

[Guest]

Thanks Lynn,
I would like to have a Menu Item (Switchboard click) to open the dialog box.
How do I program this? I tried VB code behind the Switchboard item, and
that screwed up everything.............Greg

 

[Lynn Trapp]

You're welcome.
You should write a function as part of a standard module and then use your
switchboard manager to create a choice that will Run Code.

 

[Guest]

Lynn,
I'm lost! I tried creating a macro and then a module, but nothing works.
Would you be nice enough to walk me through or let me call you? I appreciate
all of your responses, but a bit over my head on tying things together. I
wish Access was more intuitive............Greg

 

[Lynn Trapp]

You shouldn't need a macro. Let me try to give you this in a step by step
procedure.

1. Go to the code window and select Insert > Module
2. In that module write the following function:

Function OpenSecurityDialog() As Boolean
DoCmd.RunCommand acCmdUserAndGroupAccounts
OpenSecurityDialog = True
End Function

3. Save the module under some name (ex. modSecurityUtilities)
4. Run the Switchboard manager
5. Select the drop down choice of Run Code
6. Enter your function name (OpenSecurityDialog)
7. Open your switchboard and click the button for the function you called.

 

[Guest]

Lynn,
I did an insert Module which I copied your code and named it
mdlChangePassword. I then went to the SB manager and said run code and in
the third box entered mdlChangePassword. When I close out everything and log

 

[Lynn Trapp]

You don't try to run the Module (mdlChangePassword), rather you have to run
the function.