Login Forms

[CanuckChuck]

Hmmmm......I put the End If in and now it gives me a run time error 13 mismatch message and in the debugger highlights the line:

pswd = MsgBox("Please enter a new password", "Change Password")

any ideas??

Trying to follow your code I would say just before End Sub.

[MMcCarthy]

Hmmmm......I put the End If in and now it gives me a run time error 13 mismatch message and in the debugger highlights the line:

pswd = MsgBox("Please enter a new password", "Change Password")

any ideas??

Where and as what kind of variable have you declared pswd. I don't see it declared in the current code.

Mary

[CanuckChuck]

I am not really sure....I have given up on this code and have since taken the "easy" way out and have just created a command button that opens another form that the employees can click. This other form is linked to the password table, so they can change it right in the table via the form. I don't know if this is a good way to do it, but I guess it works for now?

Thanks for your continued help and patience though Mary.

Charlie

Where and as what kind of variable have you declared pswd. I don't see it declared in the current code.

Mary

[NeoPa]

Charlie,

So near to the end, is it a good time to give up?
Try posting your whole procedure exactly as it is now for me please.
I'm sure we can get this working for you (well pretty confident anyway).
Some of these syntax problems can be hard to find but I've had some experience with some doozers in my time - lets give it a try.

[NeoPa]

A new question was added to this thread as a hijack. In case anyone's interested, the new (related) question can be found at Error 2001: You Canceled the Previous Operation.