Create a Password Form

[hullstorage]

Hi all,

I am trying to create a form with a password protected screen which has my companies logo on it:

Basically i have created a form called password with two fields and a logo
which starts up when database is run.

From this i want it to do the following:
Username=John
Password=( Parcels1 )
On completion of password then start form Main
If incorrect warn them of this and shutdown database

Many thanks in advance

 

[maxmangion]

Hi,

you can do something simple such as creating a command buttom and put the following code on the OnClick event:

 if usernamefieldname = "John" And passwordfieldname = "parcels1" Then
DoCmd.OpenForm "formname"
Else
'your alternative code goes here such as a msgbox or quitting access
End If

However, there are also better approaches, such as storing your usernames/passwords in a table in your database.

So please note, that the example above is very simple to break it and still gain access to your database.

 

[coyote]

use the following link
this should solve your problem

http://databasedev.co.uk/login.html