How Do I make a Login screen

[blackwolf23]

Hello. I am a beginner with VAB . I have a login screen that has 3 text boxes( NAME,SURNAME,PASSWORD) and one button.I want to make it so that when you fill the 3 fields in and press the button it searches a table and if it finds the right combination it should look into a fields in that table that called "position"
dependent on that position it should open 1 from 4 possible forms.How do I do that in VAB. I looked everywhere either they show something to simple or to complex.

Also Are the values in the log in textboxes saved I wish to use them again in queries
And is VBA necessary for this could I use macro builder or expresion builder for this

 

[Minty]

Have you had a look here http://www.databasedev.co.uk/login.html or here http://www.access-diva.com/f7.html ?

And VBA would probably give you more control than macro's

 

[MarkK]

I just use windows security. I deem that if the user has the credentials to log on to the network or the computer on which my software is installed, then they have the credentials to use the software.

As a beginner too, you may want to spend more of your time focusing on features directly related to your purpose, because any semi-serious Access hacker is going to be able to defeat your home rolled security anyway.

My 2c on Access security.

 

[blackwolf23]

I just use windows security. I deem that if the user has the credentials to log on to the network or the computer on which my software is installed, then they have the credentials to use the software.

As a beginner too, you may want to spend more of your time focusing on features directly related to your purpose, because any semi-serious Access hacker is going to be able to defeat your home rolled security anyway.

My 2c on Access security.

thank you for the advice but this is a college project for Data base I. It wont be really used in a live environment so the credentials thing wont be of any use to me. I am just looking for a simple effective way to do this so I can get bonus points from my prof.

 

[blackwolf23]

Have you had a look here

And VBA would probably give you more control than macro's

You are right but I dont have the time to learn Visual Basic to its whole considering we will be using SQL in the next semester. Is what I am trying to achieve possible with only expression builder or macro builder ?

 

[Minty]

There is very little to learn in those examples, they literally give you everything you need.
You may be able to use macro's to achieve the same, but I don't use them so wouldn't be able to assist much.