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

[Greg]

I know it sounds stupid, but I still can't get the whole thing working. I
want a Switchboard item, in this case item 1 on my utilities menu, to open up
the change password dialog box that works in vb. How do I make it work with
the Switchboard? I'm about to go crazy!!
Thanks as always......Greg

 

[Lynn Trapp]

Greg,
I've tried to be as explicit as I know how. It sounded to me like you
created a module and then asked the switchboard to run that module. Instead,
you need to run the FUNCTION that I gave you. Without looking at exactly
what you are doing, I don't quite know what else to tell you.

 

[Greg]

Lynn,
Again, thanks for putting up with me. I've only been doing Access for three
months and I don't know how to relate a Switchboard page to a function. I'm
putting acCmdUserAndGroupAccounts in the function box of the switchboard
after saying 'run code'. Can't we talk on the phone? I will call you at my
expense. Probably, a 2 minute phone call would solve the problem and I have
to have this working by next week.
Thanks............Greg (919) 856-8286

 

[Lynn Trapp]

Greg,
If you followed the steps I gave below, you would have copied and pasted a
function called OpenSecurityDialog into a new module. What you need to put
in the function name field for the Run Code choice is OpenSecurityDialog.

I'm sorry that I can't call you. I am at work and can't use the phones for
that purpose.

 

[Jeff Conrad]

Greg,

In the Run Code function box of the Switchboard you need to put what Lynn said in a previous
message:

6. Enter your function name (OpenSecurityDialog)

Assuming you followed Lynn's instructions *to the letter* by making the module as instructed, all
you would put in the function box is:
OpenSecurityDialog

Do NOT put mdlChangePassword
Do NOT put acCmdUserAndGroupAccounts

Clicking on that option when the Switchboard form is open would launch the Access Change Password
box.

 

[Greg]

Lynn,
I now see why I'm going crazy. I am running Access 2002 and there is no
drop-down choice of Run Code. Does this help with our mis-communication? In
the Switchboard manager dialog, I have three input fields:
Text: (which I have called 'Change Your Password')
Command: Run Code
Function Name: OpenSecurityDialog
This still comes up with an error.....................

 

[Brendan Reynolds]

What error?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Keith Wilby]

I've only been doing Access for three
months and I don't know how to relate a Switchboard page to a function.

Greg,

With apologies for butting in and with the greatest of respect, you could
probably save great fistfulls of your hair if you spent a little time
getting familiar with the concept of VBA code/modules/functions and the
like, how they hang together in the greater scheme of things and how to fix
errors.

There's a great book from Microsoft Press called Access 97 Developer's
Handbook which explains things extremely well, I'm sure there is an A2002
variant which would be money well spent )

Merry Xmas.
Keith.
www.keithwilby.com