Creating a login form (how to)

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
 
D

Dave

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

Top