Form_LogIn.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 09 Jul 2008 at 10:23pm |
This sample db demonstrates a log in form with the following options:
(a) As Administrator. (b) As User. Max three attempts are allowed. If the correct combination of user ID and password are not supplied within the max allowed attempts, the database closes down. If this happens in non-administrative mode, user's account gets blocked. To start with, the text boxes for entering user Id & password have light blue back color. If the first attempt fails, a message box regarding invalid combination of user ID and password comes up. Simultaneously, the back color of text boxes (user ID & password) changes to light orange, accompanied by a label display (in light orange back color) notifying that it is the second attempt. If the second attempt fails, a message box regarding invalid combination of user ID and password comes up. Simultaneously, the back color of text boxes (user ID & password) changes to light pink, accompanied by a label display (in light pink back color) notifying that it is the third attempt. If the third attempt also fails, the database closes down after displaying appropriate message box. If this happens in non-administrative mode, the user is notified that the particular account stands blocked and the administrator should be contacted. Simultaneously, the following entries get recorded against this user's account in the relevant table: (a) Field named Blocked (Yes/No type) gets set to True. (b) Current date / time gets entered in field named DtLastBlocked. (c) Cumulative count of such blockages for this user is entered in field named BlockCount. This helps identify repeated defaulters if any. If a user with blocked account tries to log in without clearance from the administrator, he/she is faced with the following as soon as the user Id is entered: (a) Text box for entering password gets locked. (b) Command button captioned "OK" gets disabled. (c) Back color of both text boxes changes to light pink. (d) A label with light pink back color gets displayed, notifying that the account stands blocked. (e) Focus moves to command button captioned "Cancel". Clicking this command button results in closure of database. On successful log in, appropriate switchboard form (Administrator or User) gets opened. Particulars of User_ID, LogStatus and ID (PK) get stored in hidden text boxes on these forms - for further use by the developer as found necessary. Facility for change of password is available on both the switchboards (Adm / User). The Adm switchboard provides the additional facility for blocking / unblocking of user accounts. Note - If the user tries to close the log in form prematurely, by clicking the close box at top right of the form, it results in closure of database. 5 - Version: Access 2K/XP/2K3/2K7 (Access 2000 File Format) Download Access 2K/XP/2K3/2K7: uploads/37/Form_LogIn.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |