By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,581 Members | 2,023 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,581 IT Pros & Developers. It's quick & easy.

Make login form with access vba

P: 1
I want to make login form with vba
So on main form open login form and get login info from login form on main form
And should test on main form
But I can not open login form as module and can not get event that the login form will close
How I should do on this situation
Best Regards
2 Weeks Ago #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,561
Hi Genius.

Welcome to

I'm afraid I have little idea what it is you're asking. I can tell it's something about a logon form but the details seem to be words that don't make sentences or much sense.

What I can say, without knowing the details of exactly what you mean, is that in almost all cases having a logon form at all is a very bad idea. It's clumsy and in most cases totally unnecessary. You already have access to the user ID from when they logged onto the system. You can't use Access until you're logged on, obviously. It is so much better to use that than to create a separate form that, at best, will be far less secure and far more clumsy for the user.

This is an issue that has been covered before numerous times. See Function to Return UserName (NT Login) of Current User for details that may help.
2 Weeks Ago #2

Expert Mod 2.5K+
P: 3,313

You can also review this article: How to Create User Permissions and Custom Menus in MS Access.
2 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.