Tracking User Logon & Logoff from Microsoft Access. Logging When Users Start and Exit the Database.
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- In this video, I'll show you how to track each user's log on and log off times in your Microsoft Access database. We'll determine the username and computer name from the Windows system environment variables, log the user in when they start the database, and log them out when the close it.
Jason from Fort Payne, Alabama (a Platinum Member) asks: I need an easy way to track what time each user starts their database every morning, and what time they leave to go home at night. We've got a timeclock, but nobody uses it. I figure at least this way I can tell when they start working on their computers. Everyone needs the customer database. LOL
Silver Members and up get access to an Extended Cut of this video. Members will learn how to add up all of the time that each user spends in the database. We'll generate a query showing the total number of minutes spent logged in each day. We'll also get rid of the queries from the last lesson and replace them with SQL statements.
MEMBERS VIDEO:
• Track User Logon - MEM...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/TrackLogon
LINKS:
Append Query: 599cd.com/Append
Intro to VBA: 599cd.com/IntroVBA
Value From a Form: 599cd.com/FormName
Concatenation: 599cd.com/Concat
Enter Parameter Value: 599cd.com/EPV
Timesheets: 599cd.com/Timesheet
Time Clock: 599cd.com/TimeClock
Security Seminar: 599cd.com/Security
Double Double Quotes: 599cd.com/DoubleDouble
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, append query, sql, insert into, username, logon, log on, logoff, log off, logging user activity, environment variable, environ, log in, log out, login, logout, log user activity, event tracking, audit users, time tracking
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Came to watch in general like I always do not needing to know exactly how to track users but I always find something that I didn't know before hand in your videos so very educational. I've searched high and low on how to turn those warnings off and thought it was impossible to do so. You are a life saver keep up the good work.
My lessons are always loaded with chocolatey goodness. :)
@@599CD really helped me building my school software
Working on ID Card Generation
Now the problem is i have to load the image again from folder which already exit in db i m not able to fetch same pic from db
Wow! Exactly the solution I needed. And it was so easy. Thanks so much!
Thanks so much Richard, it's me Eric Muwanga from Uganda your videos are really doing wonders in my system I have developed
My pleasure
Magnificent video, 1000 percent helpfully and useful 👍
Glad you think so!
Very nice n important
Thank you🌹❤🙏
Thanks very much. May you please do a video on how to display database information on the customer display pole. Thanks
Great explanation ❤
Glad it was helpful!
WOW- Well-Done!
Thanks
hello Richard i am ELIUD MIGIRO from KENYA your recent online student in vba. some a few days ago i watched your video lesson on creating a log in logout time tracking system and i made one from your teaching. now, my challenge is that when i login and later on logout, login and logout time are recorded in different rows. is there a code that can put them in the same row? thank you.
Good method. Thanks 🙏🏿 very much. I could use this method to track when a user deletes a record (that is if they have permission).
Yes, exactly
Sir Thanks this video is very helpful
Most welcome
I have a software that turns off the computer as soon as I lose it means that it is synthesized
Thank you.
You're welcome!
Wonderful video, love your approach and application of Access, do you have a tutorial on making a logon/logoff form?
599cd.com/UserLevelSecurity
CAN I DO IT WITH MS EXCEL TIME SHEET?
Thanks so much, Richard, How can I do the same ( I would like to append to a linked table in the Sharepoint list ) could you please tell me how?
599cd.com/Sharepoint
Just what I was after - thank you so much. Not sure why but some of my users' details are not being logged. Are there any reasons that you can think of for this?
Impossible to tell from here
Thanks for the video! Is there any way to pull a users outlook email address instead of username? My users are listed by employee numbers which I can look up but it would be easier if I can pull email addresses since they have the users actual name.
There's no EASY way to do that, no. I'm sure it's possible, though. However, if you're going to go to that length, you might as well just setup REAL security. 599cd.com/Security
Richard. Is there a way to close the application when it is not in use for say 20 minutes? I already do a time event on the menu for something else. But if the programme (frontend) is open and not in use I want to close it down. Is there a way to do that?
Sure... with your timer event.
@@599CD I thought so. Do I have to do that on every form? Some forms are open but "sleeping" because the users is working in another form. Or is there a quick way out?
No matter how I do it I cannot get Dlookup to work. I can get your example to work, but that’s not what I want to do. I love the “logon”, “logoff” table and I can get the environment thing to work to put the data in the main menu form. However the user name in the environment comes back as an employee number (ie X222222). I need either the append query or and data field on the main menu form to take that employee number match it on the employee table and bring back “last name”. Everybody doing a dlookup is always doing a combo box, no, no, no, no combo box. On the employee table the employee number is indexed with no duplicates I have been trying for over a week to get this to work.
Also is there a way to cause Access to close if the user id returned from the environment is not on the table?
Without seeing exactly what you've got there, it's impossible for me to help you.
Yes... Docmd.Quit
Hi Rick,
I loved your tutorial and successfully implemented it too in my database. But i have a small problem. I have more than 1 main forms. The reason is that once a user logs-in using his user id and pw, basis his securoity level he will be directed to respective main form.
Now my question is: is there a way that log-in & log-out data can be save/appended in database from various forms through the same append queries.
Pls help. Thanks in advance.
Bharat Khatri
I do not understand your question
@@599CD let me re-phrase the question. Can the log-in and log-out data be saved/appended in log table from different forms too.
Because i have 4 main screens which open basis the user level.
how to do so, as the queries you created point to only 1st form (basis criteria)
I have an instance where my time clock was working fine for years but now a user seems to can't sign in or out.. any suggestions?
Sorry, but based on the information you've given me, I really don't have enough data to tell you what's wrong. Feel free to submit your question with more details (including screen shots) in the appropriate Forum on my web site. 599cd.com/Forums
@@599CD ok i will
Dear sir
I have a table of students where i attched a photo of each
Now i want print id cards using same pic of individual student (not all)
I searched alot but cant find the solution i again to attach same pic plz guide me to use same photo
599cd.com/Images
Sir please can you tell me how to short data of a single field with my own choice using vba
599cd.com/ClickToSort
Hi again...Great tutorial, as always!
Getting an error with the Current.Db code. When I click "design view" on my switchboard (main menu) form, I get "Run-Time Error 2467: The expression you entered refers to an object that is closed or doesn't exist."
I don't often go into design view of my switchboard, but in this instance I need to remove a text box and can't. Additionally, this leads me to believe something else is wrong and I don't want to deploy copies with a coding error buried in it.
I'd really have to see what you've got to tell you. Post this in the Forum on my web site with some screen shots. 599cd.com/AF
where is this dataset available?
What dataset?
Long-time viewer, first-time commenter here.
Do you have a video that can help me kick users out of the database?
Hi there. Welcome. I've got a video on this coming out soon.
Track last keystroke time, longer than 10 minutes, chances are they've walked away.
Indeed
I am looking for after logged in how to track the info. This is tutorial is not pointed to but the title used "Login". This is why I waste my time for watching.
You're looking for an audit trail: 599cd.com/TrackChanges. And if my videos are a waste of time, don't watch them.