runtime 13 type mismatch

[hjortsberg]

Why do I get this error??

I am trying to do

Please Login or Register  to view this content.

also doing

Please Login or Register  to view this content.

with a login frame, I want the user not to be able to just close the login frame and start working, I want the user to be forced to login...

I guess that if the user closes the login frame the LoginFlag is non existant and that is why I get the mismatch, right?

Anybody got a better solution for force my user to login before start working?

[Logit]

If you are simply trying to close your app ... just use:

Please Login or Register  to view this content.

[hjortsberg]

Ok, yes, but my problem is that I have a login frame that pops up on opening the workbook, if the user closes the login frame with the cross in the upper right corner he can just start working without entering the right password. So, what I try to do is to put a Application.Quit in various places when the user tries to push some other buttons and won't I need to put the Application.Quit inside an "if" that checks if the login is made or not???

Or do you have another solution for me?

[Logit]

Use this line of code instead. It disables the X on the form:

Please Login or Register  to view this content.

That will make them use your method of closing the form or progressing.

[Logit]

Here is a complete macro that you can paste into your form's code. It disables the X close method and provides
instructions to the User how to proceed:

Please Login or Register  to view this content.

You can add your own code to the form to close it after the above or direct the user elsewhere.

[hjortsberg]

Works like a charm

Thanks a ton!

I started with VBA yesterday and have a long way ahead of me, maybe we will talk again

[Logit]

Absolutely. I'm still learning ... alot from all kinds of folks here. Been messing with VBA for about 1 year. Lots to learn.

If this answers your question, please mark the Thread as Solved. Up top, right side. "Thread Tools"