A
Aya
I've created a form named User Accounts which consists of a Log In that
restrict access to unauthorized users. The form has a Username field and a
Password field.
I wanted to create a command button with VBA coding which can help me
restrict the access to those unauthorized users to the data modification or
elimination. The User Accounts form opens and ask the user for their username
and password. The user enters the data and clicks on the Log In button. With
the Log In button, I want VBA to check the values entered in the fields by
the user are in the Users table.
If the values the user entered are founded in the Username and Password
fields, I want VBA to show a MsgBox saying "Welcome to the system", something
like that and opens the Modify form. If the values aren't founded in the
Username and Password fields, I want VBA to show a MsgBox saying "Username
and/or password invalid. We're sorry, you are not authorized to enter to the
system..." and closes the User Accounts form.
I just have the idea of what I want the form to do, but I've no idea of how
I'm going to do it in VBA. Can anyone help me with this. I'll appreciate it.
restrict access to unauthorized users. The form has a Username field and a
Password field.
I wanted to create a command button with VBA coding which can help me
restrict the access to those unauthorized users to the data modification or
elimination. The User Accounts form opens and ask the user for their username
and password. The user enters the data and clicks on the Log In button. With
the Log In button, I want VBA to check the values entered in the fields by
the user are in the Users table.
If the values the user entered are founded in the Username and Password
fields, I want VBA to show a MsgBox saying "Welcome to the system", something
like that and opens the Modify form. If the values aren't founded in the
Username and Password fields, I want VBA to show a MsgBox saying "Username
and/or password invalid. We're sorry, you are not authorized to enter to the
system..." and closes the User Accounts form.
I just have the idea of what I want the form to do, but I've no idea of how
I'm going to do it in VBA. Can anyone help me with this. I'll appreciate it.