G
Greg Lonnman
Thanks ahead of time!
Does anyone have a form and VB code to allow users to change thei.
R
Rick B
your entire text did not post. Change their what?
L
Lynn Trapp
To change their what?
K
Keith Wilby
Lynn Trapp said:
I'm betting it's 'password' ;-p
L
Lynn Trapp
That's kind of what I figured to, but didn't want to speak for the poster.
K
Keith Wilby
Lynn Trapp said:
Well it's nearly Xmas so I thought I'd let my hair down a bit
)
I
Immanuel Sibero
hair down a bit )
We should all be so lucky.
)We should all be so lucky.
G
Greg Lonnman
r passwords. I'm sure somebody has done this and I'm not that great with VB
yet.
Thanks again.............Greg
yet.
Thanks again.............Greg
L
Lynn Trapp
hair down a bit )
Does that mean what I think it does? ;-)
)
Does that mean what I think it does? ;-)
L
Lynn Trapp
The easiest way is to open the User Group Accounts dialog:
DoCmd.RunCommand acCmdUserAndGroupAccounts
DoCmd.RunCommand acCmdUserAndGroupAccounts
G
Greg Lonnman
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
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
L
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.
behind a command button. It will open the User and Group Account dialog box.
No reinvention of the wheel at all.
K
Keith Wilby
Immanuel Sibero said:
This group isn't just for the folliclly challenged is it? ;-p
L
Lynn Trapp
This group isn't just for the folliclly challenged is it? ;-p
I sure hope not.
I sure hope not.
G
Greg
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
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
L
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.
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.
G
Greg
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
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
L
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.
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.
G
Greg
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
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
L
Lynn Trapp
You don't try to run the Module (mdlChangePassword), rather you have to run
the function.
the function.