Recent content by DragonTech

Re: Pausing VBA Code - SOLVED I actually replaced the On Enter event with the On Key Press event, using "KeyAscii = vbKeyReturn". Thank you for all your help, Paul! Your method works very nicely!

Paul, I see that you're right now. I've always assumed that On Enter meant when the enter key was pressed, and it's always worked for me. I don't really understand why it has though.

Gosh, dang it! I found a segment in my code that reset the text box to zero. Whelp, that's solved.

Then I don't know why the password form hides only when I press enter. It does not hide when I focus the text box. Anyway, that part is working for me. What I really need to know now is why GetPassword and sPassword only return a zero-length string.

On Enter is when you press the enter key. On Got Focus is when it gets focus. I used to have it as After Update, but I found that On Enter works better.

Dan, I am not using the loop method due to its limited and and intensive nature. Paul, yes I caught that. I have it set so that On Enter calls Me.Visible = False. I have tried Debug.Print, and sPassword appears to always be empty, no matter what I put into the Password text box. I believe that...

I know what the problem is now. Forms!frmPassword.txtPassword isn't returning anything. In my database, I have: sPassword = Forms!RestrictedOp.Password & vbNullString I've tried excluding "& vbNullString" but it makes no difference.

Ah. I see. Well, I still can't get it to work, though it now recognizes the function. I'm afraid I don't understand, even with the notes provided in the database.

Thank you all for your inputs! I agree with Gemma about masking the password. If an input box cannot mask the password, then it is of no use in this instance. A form has more customizability, and I've already designed the password form to my liking, so I think I'll try to stick with what I...

How do I pause VBA code while a form is open? I have a records form, and I have a button on it that opens another form. The other form is a password form, in which I enter a password to continue. However, the button continues its code regardless of whether the password form is open, closed...

Alright! Thank you for all your help! :)

Post #10 and #16 both contain the code I am currently using.

I'm afraid I'm not entirely following. I want it to go to the ELSE if one of the conditions are not met. I've revamped the code to make it do what I want, and it's working the way I want it to now with no errors. Right now I just want to know if there are any holes. You would probably understand...

The code I just posted, which is: If (lngLen <= 0) And ([cboSort1] = "Not Sorted") Then MsgBox "Insert criteria before filtering." ElseIf (lngLen > 0) Then strFilter = Left$(strFilter, lngLen) With Reports![Students Report] .Filter = strFilter .FilterOn = True...

I actually just tried the code I just wrote. It works beautifully. If strFilter is zero or negative, I want the MsgBox to come up. I don't want the LEFT() function to be called unless lngLen is positive. Are there any holes that you can see in the code?