Create Login Form with Advance Security Level Part 1 of 3

hello welcome back to my video my name is Kevin in this video I will show you how to create a login or implement login form with the different security level I got an email from our friend Falcon express from hotmail here I to see the video or he need help with the login with this different security level as he requests he because like a sick different security level or permission by the first login with admin we have the full access to will modify order until an employee record a second login as a guest to have access always view only no modification the third time is a long in that escorted control here we have the exit to view and modify edit on our his Department Quality Control Department he cannot see another department employee for login as a technical same thing to view and edit or a technical department fit log in the middle shaft department view and/or modify horah for middle shelf Department can assist login as record user we had a said to you on his own record Holly cannot see another employee department or another employee record and I will show you how to do this first we have to create some Kyle or modified security table we put sick different time in there for me on that are we implement on the create login form or program that I always show you in another video if you haven't watched it and you can go back and watch the to create login form in this one we just want to implement on that a program now we have to create table Department because in his request he have a three different Department Cora to control technical and NATO shop we create that and hopefully you know how to create the table which like this go to the Savio department ID at auto number or you can put number inside your cell and Department name is a tag that's it the next step we have to edit some secret security level before that I have already admin and user now we need to revise that being a bad mean you can add another field in here access level for or excess description in here we have case courage control technique cometo end-user and we add it on guest view only and project control view and edit oncology Control Department Olli and technical middle we even edit Ori on their Department and the six level for the user view his own record only we add this one seek permission seek level on security level table ok save that now on do I have the worker table we have username login user time a user password now we need to add department name in here because we add a department table department table and now on the design view of worker table after password is at a and department name use like a D look up like this it's already done you can see the lookup form roll sauce here from table and query the chicken here select department ID and the name and now is linked to department table by the ID Department ID which is a number or you can check on the relationship here and this one we can delete all this we can add a table as your relationship we have the table secure level already at table and consume here department ID link to Department name here and security ID need to use a time over here that's how the database link to each other and we need to add some deep silicon here Department down the case we don't put any department here and now on the admin we just leave it bang because you want to see all the department and usage a warehouse using here aside to dependent needle shop and just meet John Smith for me to shop and then si to use of time in from use of security to the meter shop - and for me - of department or either one you don't have to put department name in here because we select for Medusa tight security tie already but some case we just want to show the apartment for this worker okay now after we complete a department table update the security level and update the table worker what he requests is go to admin we have need to have full control a case view only we need to update some code on the login form first and for this because we want to set some secure level or permission when the user log in our login form here go to create even position click OK that this one are we you know chill on the previous video how to create a login form which is all this code talking about and you go to this step give the user level equal one is maddening else and then send out all this information your login ID the worker name and open the navigation form ok we want to go back to the navigation from here go to the side view we have in here we send the information you see the name here take user name when we login and then login information form you see the take user and then click login with the sip or si with the take user will be equal to full name a worker with the name equal to here the worker name matching with the take login user and ID take ID maybe show it over here it's a tech ID and now we also need the security number two because we want to pass the over here security time this one is shown as a number because it's linked to a security level table can see the resided here you see the tight security is a number we what just want to add another take ball here security time and this one maybe add like a tick take security okay for this ball we make it show first and later on we can make it invisible now we got to take security on this form save it and on the code now we need to add some more in here what we add is just copy the line here and change it to security and now we to create some color look up here we have the look of name full name and password and we need one more here we can use like in access level and put here just go be one line from here and Chaney to access level and then look up form you can go back and see what's name in here is a no user time lookup use a time okay in the table worker and then we put up nowadays take security equal to access level okay save it now we want to come by this one because we have more than one or two level we need to specify our every single level have different done XS now we need to provide the code under the login form and here in this part on we need to revise that before we go to the security level or without a security we need to open the moved it up to the after else we need to open the navigation form and aside a login ID to to take long in inside the full name or the worker to take user aside security level access level to take security and then browse it to the first page and we can delete this part out for now and we call the function I have create the functioning set secret down here set security okay we've had the security level which is pxs level excess level is an integer you can see this form here is integer and part two here and we call after we open and then when we call our security level and we need to create a sub function in security use a level from here we have the CICC different user as we specify under the security level table here admin equal 1 X 2 is K 3 to 5 so department and city's user now we have we put in a 1 it's a full control I will use the syllabus statement here case 2 equal to guess and view only s3 for Phi equal to Cora to control metal shop and technical department and we'll and edit on a dare you come in early a sig is user will be on their own quicker darling now we need to add some more hold in here after we open that navigation form psi everything near now we need to open all make the form depend on the security level then login we can test with the user you know the message back here as you log in as a user for number 6 and with Department equal to department ID and we put in here Department depart ID as integer and now we need to add some here - Deb ID welcome from the my day we need to add some more ah another live code here in here I reset the department Department ID is a as individual foot who named me department ID department ID equal to D look up on the department and okay look up on this one department name Department name okay and we pass that one to Department ID here and then pass it to the function security equal to Department ID here for now when we log on to the as a user we need to disable the admin function which is over here admin page the name of this is navigation button no 13 and we we can we have make it visible for now and here you want to see the login ID save clothes now we taste log in the form it would G when one two three four okay and Department we have two t in here which is great now we log in as a user because the security tie is sick and G when is long in ID pass from the login form to the navigation form and full name is John Wayne and if I'm in ad equal to 3 which is equal to 3 will here is made of shop and before the show here G when user has made a shop here see and which is good on and then the admin page is disabled if we log in as a user with the secret level is 6 6 min user and allowance J John Wayne and my info is supposed to be show John Wayne in here we need to go to the side view I need my info and click on the form double clicking here you will see on the even we need to update some code on the glory win when we open this user info tab will be or issue under you name all the user login name we go by aside in useful answer dream leave my love in F in tissue game time and string and si you should equal to to work to form navigation form navigation form and when come from that one it come from here you see the order is take log in the take long in King the login user phone there and then assign my login ID d look Dom will the ID from table worker and Quechua is login ie equal to single code in depakote address of user number course in code in the book hole and si it has equal to six statement sir call for table open where work ID equal to this integer we need orissan double core my log in and then s I need on pickle sauce here equal to task and Nestor same clothes and we run it is when here and the log in G wing will be great online for support to be chillin on we can disable this one because we don't want to use of the chain then click on design view and click on here we can put kick on data and above put no hello yes and now we cannot create on issues because we lock up you ending user to change our security tile security level they can change a password or change the name ok we done with the SI or either the user record to the user login

Channel: T Golden Eye

Views: 100,045

Rating: 4.8279572 out of 5

Keywords: Howto, how to, access 2010, ms access vba, MS access 2010, vba access, access tutorial, create login form, log in, security, set permission, set security, log in form

Id: gAKmPnAnXSM

Length: 22min 49sec (1369 seconds)

Published: Sun Jul 20 2014