I've been using a form built straight out of Microsoft Knowledge Base Article
- 200665 and for the past few months to have users change passwords and it
had worked just fine.

Recently however, I starting getting a default Microsoft error that reads
"There was an error running your request - check that all fields are properly
filled in." I've gone back to many archived versions of the form to see if
something by accident was changed, but all older versions produce this same
result on my development and test systems. I am clueless why this started
happening. Any ideas?

Thank you

That doesn't sound like an error that you should get from running the
code in that article. Are you sure it isn't coming from the code that
*calls* that code?

The first think I would do, is to comment-out the following statement:

On Error GoTo ChangeResetPassword

Then, if the error is occuring inside that code, it will stop on the
actual line in question, instead of going to the error trap at the end
of the code.

HTH,
TC

I am trying to set up a form to allow users to change their own password. I
used the code in Article 200665 and get a compile error message "Ambiguous
Name Detected: ChangeUserPassword". I'm not sure of how to call this, can
someone help?

"TC" wrote:

> That doesn't sound like an error that you should get from running the
> code in that article. Are you sure it isn't coming from the code that
> *calls* that code?
>
> The first think I would do, is to comment-out the following statement:
>
> On Error GoTo ChangeResetPassword
>
> Then, if the error is occuring inside that code, it will stop on the
> actual line in question, instead of going to the error trap at the end
> of the code.
>
> HTH,
> TC
>
>

That would imply that there is more than one public procedure called
ChangeUserPassword, in your database.

Find the duplicates, see if they are the same, and if so, delete all
but one of them.

Take a backup of your database first, just in case you muck it up!

HTH,
TC

"Mary" <(E-Mail Removed)> wrote in message
news:A3CFCB23-767C-4C5F-BFC2-(E-Mail Removed)...
>I am trying to set up a form to allow users to change their own password.
>I
> used the code in Article 200665 and get a compile error message "Ambiguous
> Name Detected: ChangeUserPassword". I'm not sure of how to call this, can
> someone help?


The module should not have the same name as the sub. That may be the cause.

--
Joan Wild
Microsoft Access MVP

Sorry for the delay. I did have a "test" module that once deleted removed the
error.

Now I get a new permissions error: You don't have the necessary permissions
to use the "myobject" object.

I am the db owner.

Any ideas what I did wrong this time? Thanks!

I used: http://support.microsoft.com/default...b;en-us;200665 to
set up the form - frmChangePasswords and the module SecurityCode.




"TC" wrote:

> That would imply that there is more than one public procedure called
> ChangeUserPassword, in your database.
>
> Find the duplicates, see if they are the same, and if so, delete all
> but one of them.
>
> Take a backup of your database first, just in case you muck it up!
>
> HTH,
> TC
>
>

Hello again, I logged out and back into the database and found that my
password actually did change, even though I received the error message. I'll
look at the Err code. Thanks, Mary

"Mary" wrote:

> Sorry for the delay. I did have a "test" module that once deleted removed the
> error.
>
> Now I get a new permissions error: You don't have the necessary permissions
> to use the "myobject" object.
>
> I am the db owner.
>
> Any ideas what I did wrong this time? Thanks!
>
> I used: http://support.microsoft.com/default...b;en-us;200665 to
> set up the form - frmChangePasswords and the module SecurityCode.
>
>
>
>
> "TC" wrote:
>
> > That would imply that there is more than one public procedure called
> > ChangeUserPassword, in your database.
> >
> > Find the duplicates, see if they are the same, and if so, delete all
> > but one of them.
> >
> > Take a backup of your database first, just in case you muck it up!
> >
> > HTH,
> > TC
> >
> >

Got it working - thanks for your help!

"Mary" wrote:

> Sorry for the delay. I did have a "test" module that once deleted removed the
> error.
>
> Now I get a new permissions error: You don't have the necessary permissions
> to use the "myobject" object.
>
> I am the db owner.
>
> Any ideas what I did wrong this time? Thanks!
>
> I used: http://support.microsoft.com/default...b;en-us;200665 to
> set up the form - frmChangePasswords and the module SecurityCode.
>
>
>
>
> "TC" wrote:
>
> > That would imply that there is more than one public procedure called
> > ChangeUserPassword, in your database.
> >
> > Find the duplicates, see if they are the same, and if so, delete all
> > but one of them.
> >
> > Take a backup of your database first, just in case you muck it up!
> >
> > HTH,
> > TC
> >
> >