Hi there,
I have a database that i'm looking to password protect with a user login form. The users are all on a combo box which is being gathered from a table. The table also contains the passwords.
A query fetches the username and password from the table by the criteria set to the combo box in the login form.
I know, it's very bad "security".
What I'm looking to do, is that when the log in button is pressed on the login from, some form of VBA collects the password from the query, stores it in a variable so I can then use it in an if statement.
Any help appreciated. Also any suggestion on how better to make a custom security system would be good. Im still a intermediate so please...nothing too complex
I have a database that i'm looking to password protect with a user login form. The users are all on a combo box which is being gathered from a table. The table also contains the passwords.
A query fetches the username and password from the table by the criteria set to the combo box in the login form.
I know, it's very bad "security".
What I'm looking to do, is that when the log in button is pressed on the login from, some form of VBA collects the password from the query, stores it in a variable so I can then use it in an if statement.
Any help appreciated. Also any suggestion on how better to make a custom security system would be good. Im still a intermediate so please...nothing too complex