Create Login Tracking Database Part 3: MS Access

hi welcome back to the third part of this view this step will show you how to create a function to display the Tom okay we need to create under the module which is we can use in anywhere on any freefall we start with the function this take time and you start as a dead finish as day because we need to like vlog start time and the ending Tom place login Tom long outcome format a string in F MTS thing we wanna start with dim we need to get the hour long minute that's long us for a second we need to get the total second form or the income interval from the beginning comments log out town total second and then secondly because long-handled a decimal point here we start with the Toro sake that equal to 1 equal to dead a friend of a second format a start and finish now we got through to second to the second how many total from this from the login and a lot of time and we need two hours equal to integer about total second divided by 3600 one hour equal to 60 second time 60 minutes equal to 3600 and the second flip after our secondly equal to total second we use mod the remainder over 2600 and minute equal to in a second Lee divided by 60 second whatever the second that is how many secondly and we divide by 60 we call the equal to 60 second equal to one minute and then we get the minute okay now we can our and a minute we don't want we don't care about a second leg okay now we need to get the format to show on the report you want to show the minute and the hour and the minute the user silly a case if MT over here from the format here Beauty use a case time wrong the code is our and we need em in silly now under the sick use if ours equal to 0 then this pre Tom is formal here is free time equal to minute if it's less than hour we just showed a minute we don't want to show zero hour you just want to show 59 minute endless minute am i I I am is me naive function minute wrong okay meaning not equal to 1 then - Oh minutes if equal to 1 or 0 show minute in a is more than one minute to three minutes we want to show these minutes with this and if this one and we do not show ask me for just minute okay because the coral sink around 400 then else this pain in Coffeyville here I have this pay hours and I I if I was not equal to one show hours or here is one a show our m and and then the minute we copy here copy the whole thing over here and minutes same thing and if if the hour is not zero and then we need to show the hour and minutes look like good showing here we use the format bomb and equal to sample line 100 hours 15 minutes it's a 4-man example and the dead different is format the different up-to-date Oh tom because we need to start or finish didn't start off in its home and in function looks good now we need to try this copy the function display Tom and then put this login time and then log out come here and then format we use the format - m and save and go to this on view on this report now we need to change this and under the Builder machine function is you see when we use a disparate time we need to start finish and format 15 studies long see we have we here login now log out the feel here easy and format shape ish em and hold prentices is done save it view the report now is user friendly for the login time it should use the name UCD and long in time it's the same day and less than an hour because we start at 9:00 for call my p.m. and stop after nine 21 it showed 21 minutes with this but this one we need a little bit sped in here David we just go to the car show and we just need to skip them space and the font here and here and then owl and house here and mint spared on the back of our - we need to give the space before the minute start okay it looks good well open the report again now we have the 21 space minutes okay we want to taste one minute what is gonna show in there open here we just put one one nice your throat a lot of at night one maybe one minute and open there before now is one minute is no is because we set up the function f is e equal to 1 or 0 it just used like minute minute no mid noise which is Cora comma for synchrony look like it's working you know how to create law tracking you know login user track the user whose log in log out in your database and how long they log in and you can use create one cable long in time and a query log in user app in query and logout time user updated query and now show you how to create a function display Tom and use it in the report and thank you for watching and always tell you on tracking your user log in database thanks

Channel: T Golden Eye

Views: 8,302

Rating: 5 out of 5

Keywords: Howto, how to, access 2010, ms access vba, MS access 2010, vba access, access tutorial, create login, tracking login, login trackin, how to create login tracking, trackin login database

Id: -AHRbNGqSJQ

Length: 13min 19sec (799 seconds)

Published: Sun Mar 09 2014