Tracking User Logon & Logoff from Microsoft Access. Logging When Users Start and Exit the Database.

[@neilbrown6157]

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.

[@599CD]

My lessons are always loaded with chocolatey goodness. :)

[@mathmagics8212]

@@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

[@muwangaeric2167]

Thanks so much Richard, it's me Eric Muwanga from Uganda your videos are really doing wonders in my system I have developed

[@599CD]

My pleasure

[@shemtusiime6478]

Thanks very much. May you please do a video on how to display database information on the customer display pole. Thanks

[@johnsonofjohn1678]

Wow! Exactly the solution I needed. And it was so easy. Thanks so much!

[@MBKCZAR]

Magnificent video, 1000 percent helpfully and useful 👍

[@599CD]

Glad you think so!

[@premshah6200]

Very nice n important Thank you🌹❤🙏

[@migirooruru2488]

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.

[@iljanov]

Wonderful video, love your approach and application of Access, do you have a tutorial on making a logon/logoff form?

[@599CD]

599cd.com/UserLevelSecurity

[@abdulhamidalhaddadi2255]

CAN I DO IT WITH MS EXCEL TIME SHEET?

[@mikewashington4188]

Good method. Thanks 🙏🏿 very much. I could use this method to track when a user deletes a record (that is if they have permission).

[@599CD]

Yes, exactly

[@chamaradw]

Great explanation ❤

[@599CD]

Glad it was helpful!

[@nayyerabbas3957]

Sir Thanks this video is very helpful

[@599CD]

Most welcome

[@nayyerabbas3957]

I have a software that turns off the computer as soon as I lose it means that it is synthesized

[@joseancheta3817]

Long-time viewer, first-time commenter here. Do you have a video that can help me kick users out of the database?

[@599CD]

Hi there. Welcome. I've got a video on this coming out soon.

[@neverseenbefore1382]

Sir please can you tell me how to short data of a single field with my own choice using vba

[@599CD]

599cd.com/ClickToSort

[@MrAimalsultani]

WOW- Well-Done!

[@599CD]

Thanks

[@midoallam1659]

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]

599cd.com/Sharepoint

[@embren11]

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.

[@599CD]

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

[@leonthompson1976]

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?

[@599CD]

Impossible to tell from here

[@oldbrokenwrench]

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?

[@599CD]

Without seeing exactly what you've got there, it's impossible for me to help you. Yes... Docmd.Quit

[@userseventyeight]

Thank you.

[@599CD]

You're welcome!

[@fredzwalm5429]

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?

[@599CD]

Sure... with your timer event.

[@fredzwalm5429]

@@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?

[@raboops]

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?

[@599CD]

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

[@raboops]

@@599CD ok i will

[@carmelcream85]

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.

[@599CD]

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

[@AustereShipping]

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

[@599CD]

I do not understand your question

[@AustereShipping]

@@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)

[@mathmagics8212]

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]

599cd.com/Images

[@divyasrik344]

where is this dataset available?

[@599CD]

What dataset?

[@gregoryjeffries8475]

Track last keystroke time, longer than 10 minutes, chances are they've walked away.

[@599CD]

Indeed

[@user-ss9cg1qk1i]

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.

[@599CD]

You're looking for an audit trail: 599cd.com/TrackChanges. And if my videos are a waste of time, don't watch them.