How to make a login interface with macros in access, I made one, but the login screen can t turn off

For this, first of all, you have to be able to use macros, otherwise you have to be able to write VBA.

For multi-user login, you can write programs in VB, or you can make a basic user information in Access and enter the user information first.

The logic is to use macros or VBA to check the consistency of the entered account and password with the account and password in the user table.

A little deeper, that is, you have to make a table, make a login form, the login form is just like the QQ login, make a text to enter the account, make a text to enter the password, and then make a confirmation button, make a cancel button, confirm that the program is written in the click event in the button, and the program will be compared when you press it. Close the login window if it's correct, and warn you if it's wrong. It's very simple, I believe you are so smart, you can understand it when you think about it.

If you don't understand it anymore, please add the wealth value to 500, and teach you how to do it hand in hand, it's not that I'm too greedy, but you're too picky, such a complex project, how to learn 30 wealth values, well, you must add more, it's too little.

Well, that's it.,It's OK to ask your class that Zhuangzhuang.。。。

Create a macro -- select OpenForm in the "Actions" list -- Select the name of the form you are logged in to from the "Form name" drop-down list in the "Action Parameters" area, the save name must be Autoexec

You need to set it in the database options.

To create a new form, the connection is to use the trigger on the form to dig holes, such as button click, double click, text box to get focus, content change, click to scatter and so on.

The key to this technique is to use the dlookup function to teach whether the password is correct.

private sub login_click()if isnull(me.username) thenmsgbox"Please enter your username! ", vbexclamationelseif isnull(password box) thenmsgbox"Please enter your password! , vbexclamationelseif key1 = dlookup("Password", "User Information Table", "Username ='" & me.Username ="'") then

Login screen" 'Open the login screen.

elsemsgbox "The password is incorrect! ", vbexclamationend if

end sub

Here's how it works:

You need to use a VBA for this.

Make a table of users, including usernames, passwords, etc.

Bind the data source of the login form to the user table, and then compare the username and password of the text box with the data source, and you can log in at the same time.