Login Dialog not working

The part of three failed attempts is not working. Please help with this. Thank you!

Please Login or Register  to view this content.

The problem is that after the 3rd attempt, the message box" "You do not have access to this database. Please contact your system administrator." does not come up.

I'm going to agree with OnError. Exit sub in your else block is causing you to exit and when you come back into the sub, so your attempt variable is reset to 0. Which kind of makes me think that you need to declare the attempt variable as static. You would also need to initialize that variable on the form load event to 0.

My suggestion,

Please Login or Register  to view this content.

I'm really leaning at you have a variable scope issue. Each time the user clicks go, the attempts are reset to 0. With static, the number should be saved until the form is closed and is re-initialized.

I was assuming that the user was clicking the button again to enter the password that would re-fire the event. Just setting the focus to the textbox wont do anything but point the user to the wrong input. They still have to resubmit the new information somehow. Having it inside a loop esentially doesn't do anything. I can only assume that without exit sub it would hit the 3 attempts quickly because there isn't anything stopping execution when the event fires, while the user enters new data. Unless .setFocus does something I am not aware of for validation. If .setFocus does halt execution then yes. Getting rid of exit sub will work.

To fix the attempts you could reset the static variable to =0 after a sucessful login then you always start fresh after a good login.