How To Log User Activity In Access 2013 🎓

How to Log user Activity in Access 2013. In this video instructor Steve Bishop explains how to set up a log table, create a function for logging, and how to track logon and logoff events for Microsoft Access 2013 databases.

----------
Become a member today for only $5 a month!

When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
----------
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.

[kevinebeleadinnu]

Good morning Steve,

I have watched 90% of the videos in your basic series. I write to express my unquantifiable gratitude. From zero knowledge of Access, I successfully delivered to my organisation two applications that have changed the way we work to the appreciation of all and to the amazement of our IT department. I face customers in the front office.

My management is indirectly very grateful to you by having these applications at no cost. They are even asking for more.

I must say that the log of user activity which I implemented following your guide beats the one in some applications we paid dearly for. Some do not even have audit trail.

We cannot thank you enough for making something I used to consider weird so simple.

It is time to try my hands in the advanced series while perfecting my basic knowledge.

The year has not finished but you have already made my year.

Thank you. Thank you. Thank you. Thank you. Thank you.

[wilsonfineart]

An advantage of using a separate table for logging is that you can add logging features to the front-end without needing exclusive access to the back-end. So, in production, users are not affected. An issue is when a new record is added to a table via a form and you'd like to log the ID for that new record. The ID for that new record is not set until the record is saved.

[nanettehughes]

Thanks Steve, I have been watching your basic videos from the beginning,  I didn't realize you had advance. I will continue on. Thank you for your time.

[omersharif]

I think it would have taken me three lifetimes to do this on my own. THANK YOU! GOD BLESS YOU!

[jmathew]

This is gold! Just made my day.

The video comprehensively covers the topic I wanted clarity on. Today is first time I have viewed any of your tutorials and immediately decided to subscribe to your channel. I'll be viewing other tutorials as well in coming days because I am currently working on an MS Access project.

Thank you.

[mattlane]

Steve bishop you are a saint. You have helped get a promotion at work!

[rondaficklin]

This video was FANTASTICALLY helpful!!! I wanted to track changes to a combo box on a form. I created a table with ID, Date, ComboBox, ProjectNameID and Activity. I had to create 2 text boxes on my form (one for the project name, one for the combo box selection) I hid these txtboxes. In VBA for my Form - On click of the combo box I entered, TempVars("ComboBox").Value = Me.txtComboBox.Value (hidden),  TempVars("ProjectNameID").Value = Me.txtProjectNameID.Value (hidden),   Globals.Logging "Update".I then created a Globals module and typed in: CurrentDb.Execute "INSERT INTO ComboBoxLogAccessT (ComboBox, ProjectNameID, Activity) Values(' " & TempVars("ComboBox").Value & " ', ' " & & " ', ' " & Activity & " ')".

[MRTOMBO]

High quality presentation style, pacing, and organization, in addition to your targeting of specific tactical tasks / modules people are trying to create in their tool sets for assembly in their applications. This has helped me tremendously, specifically because of HOW you go about it.

Bravo.

[darrengodkin]

I'm really enjoying your videos and the style of delivery.
I found them very useful in my Access Learning projects, Thanks for taking the time to make the videos!

[naqeebahmed]

Thanks for the Great Tutorial . i have a Question if i want that which user made changes to which records ? Can i record these all as well . for example if user 1 enter some new records and also he edits some records . and Admin can check that which records are added by which user and which are updated by which user? Thanks in Advance.

[jungjungdelosreyes]

What a wonderful video Steeve. You are a legend!

[Muuip]

Congratulation on a great concise, plaisant presentation!Audit Trail has been missing on my DB for a while now and finally found a professional Video.Many Thanks!

[Jojosmith]

thumb up for the very valuable tutorial. Already subscribed. is there anyway to allow managers to full access to report/forms while other users have only full access to forms for data entry? except changing forms design thanks a lot

[CrispyA]

I just started up with Access 2007, I'm not totaly new to other Office programs but your videos have allowed me to jump leaps and bounds as a beginner.

Thank you for taking the time.

A friend and I are about to start a new small business and I was wondering if you could put a basic tutorial together on how to enter and remove inventory items, so that the Inventory will update based on that criteria?

Regards,
Chris

[namma]

Thanks Steve for sharing and preparing this video with us it's very easy to understand it 😎😎

[ahmadhussein]

Perfect Job Mr. Steve, Could you please share the link of "How to" playlist

[rebiaitarek]

Bravo !! amazing tutorial and your way of explaining is just amazing!! i do have one question, how can i show the logged username in one of my printed reports? thanks in advance

[mohdhtm]

Great work, Thanks
- Questions please:- How we can log & track other opened form on the same activity table?
Thanks in advance ..

[FreeHappiness]

Your videos are great. Can you please tell me how I can log a particular ID field if the the user made changes in that form. What will be the script for directing it to include the ID number on that particular form. Thank you

[samarthjain]

Hi Steve, this is the first video I saw from you and really liked it. I was wondering if you can add to this tutorial on how to log activities such as adding a new record in a table or modifying an existing record. Thank you for your help.