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

  • Thread starter Thread starter Guest
  • Start date Start date
Lynn Trapp said:
That's kind of what I figured to, but didn't want to speak for the
poster.
Click to expand...

Well it's nearly Xmas so I thought I'd let my hair down a bit :o)
 
r passwords. I'm sure somebody has done this and I'm not that great with VB
yet.
Thanks again.............Greg
 
The easiest way is to open the User Group Accounts dialog:

DoCmd.RunCommand acCmdUserAndGroupAccounts
 
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
 
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.
 
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
 
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.
 
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
 
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.
 
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
 
You don't try to run the Module (mdlChangePassword), rather you have to run
the function.
 
Back
Top