Create Login Tracking Database Part 2: MS Access

they opened an invitation for me if you get this message you are about to run it if inquiry you see when you open the form you cannot run the app inquiry and you answer yes and now is argue about to up app in one row to the table and it did but is amazing and even though I processes are me again to update the tool we call that message form the action query it to confirm that you want to run a query if we don't want to see that a pop up again we need to update or insert some code in there we call set a warning to for we do the command set warning see here and for before your brand new query after you run and we set command t26 warning - now same thing we do on the course in step 4 and warning - we use this a command warning for and men running - and sip warning - on the app in query update query or delete query we use them this command for for that to disable data error message or confirm confirmation or confirm message on them save and then now when you open the form you're not gonna see any problem SE o use you save now you caught the form and you're not gonna see the message again try again please no message or sit no message but the information is updated and add it on to the login table you just need all this okay the next step on the second part of this video I will show you how to use that long in time on how to make the report from the login table okay we wanna see whose login and how long they log in but first we need to create a query queries and login time we add all these and make it show here now we have one record at login I can change the time to 0-0 make it longer as long in 9 p.m. and log out at 9:21 will be 21 minutes but we don't know what their name is maybe they have you know always show already the user login ID from the computer go back to view form we have to add another table from the users table now the log user login equal to use a login over here we link it and then we put the username drag it over here and move it at the front here and view now you can see that because it's linked by the user ID and you get the PO wing which is open a user table you see the photo in here and use a login system one and you come up with the query of wrong income wrong outcome or polling okay and now we save it as query log in the next thing we can use this information from the login query to create the report go click on auto report now we have some kind of auto report shown here we can change the name login report and we make it smaller fill shorter and we need to add another field over here we name it as a log in time how long for long in so nice now and we'll okay we have the log in time and show date and time and we have a log out date in time but we don't know how long is it we need some color can creation over here subtract that and to show how many minute how long okay example if we use in here long outcome - long in time and view it save report login okay see now if you use a shrub track log out Tom subtracting log in time you come up with some kind like you know integer ticket does is point zero one four which is um parent node is some kinda like a time interval number it's not useful for us we need to create some kind of a function now to to chew as an hour and minute I wish you all you are the next video thank you a piece for me on the third part I will show you how to create the function to show hour and minute and put in this report Thanks

Channel: T Golden Eye

Views: 10,399

Rating: 5 out of 5

Keywords: Howto, how to, access 2010, ms access vba, MS access 2010, vba access, access tutorial, Login, Create Log in tracking, create tracing, log in tracking databas, create log in trackng

Id: VAcb0Lina34

Length: 8min 1sec (481 seconds)

Published: Sat Mar 08 2014