Creating a login form (how to)

  • Thread starter Thread starter chang
  • Start date Start date
C

chang

how would i be able to create a login form? i dont nead it to have a
username and password, just a password would be good enough.

thank you
chang
 
Hi,
Firstly, you'd need a table which defines who is allowed access OR the password used to log in.
Create a form with an unbound text box which looks up the user field in your table. You can then have the database open a default form for everyone or a specific form for each individual user.
Another way is to have the form's unbound text box open with a default value of the person who is currently logged onto the machine. (use the Environ("username") function).
You'd want this form to open at startup, so put it in the Startup options or create an Autoexec macro.
Hope that helps.
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Login to an Access Application 4
Restricting access to database using forms 4
Windows 10 W10 password prob. 2
Eeek! I am forbidden access? 12
login table and login form 8
Login Help! 2
Expiration notification 4
Users log 4

Back
Top