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.
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.
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.
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.
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!
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 & " ', ' " & TempVars("ProjectNameID").Value & " ',' " & Activity & " ')". Perfection!!!!!
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.
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!
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
Crispy2012A That is a very specific request that requires intimate knowledge of the database you are working out of. Afraid that makes it difficult to do.
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.
I am so glad you enjoyed it. Unfortunately there was a little trouble syncing the audio with the video. Something happened to the desktop recording software.
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
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.
When it comes to tables, you cannot log changes unless you use macros. You are better off logging changes through the forms. If your users are able to access data directly in the tables, then you have a very serious security issue. Users should NEVER be able to open tables directly.
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
Thanks for such nice videos, i loved your videos. I have question for multiuser login system. 1. Created user registration form, any user can register by his own. By New user. Once his registration is complete, he can login. 2. Bu for this I want user ID (login ID) for login purpose but not the actual name of any user. So I created query to create "User Name"(login ID) by using user First and last name 3. Now I want use that "User name" /"login ID for the login form. Dont know how to connect that, because my user name is existing in query (userExtended) but not in User Table. So that user can login with loginID.
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
Hi Steve, are you able to create a tutorial on how to log changes to records (indicating changes made, user info, & date-time stamp? I really hope you can.. thanks a bunch!
If you are just allowing people to modify data directly in a table or query, then there is no way to record log activity. If that is the case, then I HIGHLY recommend you stop. Giving people direct access to the data is a recipe for disaster. You should only allow people to use forms and reports. Then you have the advantage of coding the UI with VBA and hence log all changes using the method in this video, and that would include record changes.
Thanks for the videos. They really help. Can you create a video showing how to automatically backup a database using VBA code every time the database is opened?
really easy to understand many thanks can you please make examples on how to add more details like Computer Name, Windows logon, you talked about that but i like to see examples. cheers
Sham Kasturi Since the table is automatically filling in the date and time, it's going to be where the table is located. You could change that by changing the value in the recordset from the front end with now() in VBA.
Great tutorial! Thanks so much. I am already tracking user additions and modifications to tables, but this will add to the information my client wishes to gather. Is there a simple way to track when a user runs a report, if that report is a button on the dashboard? Would you put the code in the dashboard form or in the On Load report form, or would either work? Once again, thanks! I'm definitely going to check out your other videos as I'm sure I could learn a lot.
Hi there, Great video tutorial. I am getting a compile error: Argument not optional on Logon & Logoff. I am trying to add environment variables to retrieve the Windows UserName and WorkstationName and enter into the logging table. Could you please advise how to resolve this. Thanks
Hi Steve. Great tutorial! I also need to track the changes made on other forms in my db. Do you have another tutorial regarding tracking these changes?
+Programming I am new to programming and I don't know how this function would give me the value that was changed and what the value was changed to using this code. To me it seems like it will give you whatever message that you tell it to give you when the data is changed. Again, I am sorry for not understanding, I am new to coding.
+shezgill I'm afraid any How To video I do requires you to at least know the basics of Access development. If you're interested I have a basic series on my channel.
+Programming I've seen your videos and they are great. I haven't seen any help regarding what I need but thank you for your videos. They are still some of the best that I've seen.
+shezgill I understand that none of my video's specifically cover your question, but what you are looking to do requires that you know how to watch for event that happen in your database (which I cover in the basic series), then call this function with the proper arguments (which I cover in the basic series). I'm afraid after that it's a matter of you being able to piece together the bits of knowledge to come to your own solution. That's what programming is all about!
+garantina101 Sure, just make your text you pass in have some sort of indication that the action was a login or logoff action. Then write up some queries to total up the difference between those two actions. Be careful though, if someone just exits the application via taskmanager or hitting the close button it won't trigger an event. I suggest you make sure the close button (X in the upper right corner of the window) is not available.
Hello Steve! Thanks again for all your help. I've got a wee touch of a conundrum, and am hoping you can get with a syntax issue. it may not even be possible to do what I'm trying to work out. I've got everything set up the way you've suggested above, and it works beautifully. Yay!I'd like to pass as one of the TempVars the name of the form that the user is currently on before they leave the form for the next form. How would I write that particular bit of code for the TempVar? I tried TempVars("FormName").Value = Forms!Loginwith the thought that I could change the form name portion for each page, as there are only 9 pages total. But then I had several thoughts - a) the db is likely to grow making it quickly become unruly; b) that particular reference will not work as TempVars prefer to look at data and not datasets; c) I could Dimension the form name as a string and then reference it after the = as such, but that would likely have negative repercussions as the form is being used as a form object at the time it is being Dimensioned as a string, creating an internal conflict.So I am left with zilch ideas. Is there an easier way to pass the current form name into the TempVars? Thank you again!
I'm not sure why you can't just set a TempVars("LastForm") when the form is deactivated. You could also have a TempVars("CurrentForm") value set when the form is loaded so you are keeping track of both the last form and the current one.
Never heard of either one, didn't know what to look for, now you've given me not one but two options and I KNOW you are the best - WOOT!!!!!!! (And talk about Speedy Gonzalez on that reply!)
Wait, I got so excited I completely forgot, my original question still remains, what comes after the equal sign? How do I refer to the form name without actually calling the form? TempVars("CurrentForm") = _________ ?
Tammy Bergen Well if you're executing the code from the module behind the form, then you can get the form name by just doing me.name. So TempVars("CurrentForm") = Me.Name
Hi Steve, i am struggling with the logout part. I did this exactly like you and placed the logout part in the form_Unload event. If i use the X button on top of the Acces application form it works as expected. If i use a button with a Docmd.quit that i placed on my Menue form it doesn`t write the logout? Strange, huh? Hope that`s not a bug in the 2016 version of ACCESS. Anyway thanks so much for your great channel. Much appreciated!
I got this to work after a bit of trouble shooting. I was placing the code to call the function in the wrong place in the VBA code for the "Login" button. It needs to be right before the "End Sub" line.I now have a couple of questions. Firstly, I opened the log this morning to track user activity and found several records with no username, just blank. But there were records for all the known users I was expecting to see. Any ideas on how these could have been generated? I expect that it could be from failed logins. If that is the case could I run the table through a query with an "Is Not Null" parameter on the username field. ??Another question. How can I generate a list of "Currently logged-in Users"? Is there a way of specifying users who have logged in but not yet logged out? Maybe something line a count of users that are uneven indicating logged in but no matching log out?
Hi Steve, is it possible to add in how users able to reset their own password? and do you have tutorial vids on how to create user's page and from that page we could see their activities or history maybe
Hi Steve : and thanks a lot for the nice videos , Is there any way I can track all the changes that were made by specific user in a specific record ? . thanks in advance .
It depends on how you are allowing the user to interact with the record. If you use recordsets in VBA it will give you an opportunity to use the function from this video.
Programming thanks Mr Steve. actually all what i need is to know when and who have created a specific record and if it was updated then I well get when it was updated and by whom ? I have seen your video 53 and i believe it is so close but I couldn't make it ..
Hello Steve. I'm enjoying your video's I find them helpful and easy to follow. I am setting up an employee time db. They will be entering a Project No and the amount of time spent on it. I have created a form that is filled out by an administrator, it has USER NAME, PRODUCT LINE, START DATE and END DATEI would like all this information to be added to a report that I have already created. I have also created your login form. How do I go about doing this?Thank you for your timeNanette
I have utilized your expertise from this video. Thank you. However, when I eventually split the database and saved the two ends in separate folders (I did update the table link manager to access the proper back end file) my users, not me, are receiving an "On Click" error code that leads me to believe there is something not converting from your prescribed VB coding for the event. Any words of wisdom on this?
You just call the function for every action you want to track. So if it's when the user makes a change on a combo box you call the function on the change.
Hello Mr. Steve. Great video. Question. At 16:20 in the video, you created a globals to pull the logging function. I cannot get my code to do the same. I repeated your code but I still get error. Any ideas?
+Programming it's okay. I figured it out. Global is the name of your module. I thought it was a built in Access function. My module is named GetLogIn. once I made the change, it worked perfectly. I'm new to programming. Thanks again for the video!!!
Hello Steve, thank you for your videos. I have a splitted db without login process. It located in a network folder. I need to know how to disconnect all users from the db to implement my updates. The file is locked while in use. How do I manually disconnect users from an access db?
It's a bad idea in general to disconnect users if they still have data open in their front ends. I would suggest waiting until everyone is done rather than trying to force them off. You will likely cause some data corruption if you do.
Yes, I agree it's bad idea to do this without notifications of users and saves. But for example someone left the db open on the weekend or till next day and I strongly need to do my updates. I can't wait so long. It would be nice if you made a video how to notify an user of front end that maintenance of the db is required. If user not responds, it will save data automatically and close access application. I think many of developers will tell you "Thank you so much !"
There is no simple way to do this, nor a fool proof one either. I suggest moving to SQL Server where this is no only capable of being done, but is built right into SQL Server.
Hi Steve, love this function to monitor activity. Now i want to monitor changes to a record and found a way (using this video) to get an activity logged when a field is changed. But i want to see witch record were changed of the field, is there a way to get the recordID with this changed field ? (hope i make any sense in my question) :-)
+RichBu22 Unfortunately the function can only be called from within VBA. Since table data changes themselves do not trigger any events we cannot capture changes when data is changed. What you can do is capture the change on a textbox though. So if you display the data on a form and the user can change it there, you should be able to use this function to record that.
Steve, haven't been able to find an instructional video on how to transition a form that rotates on it's horizontal access i.e. form turns counterclockwise and then reveals the sequential form on the backside. Surprised there is not a lot out there in Access that takes advantage of the visuals that PowerPoint has for transition options....I've seen it on the web, but unclear how it's done...possible for you to create the video?
Programming Can't find it now, but think about a piece of paper you are holding upright and then turn the page to see the backside...the First form on front, second form on back. When the form has turned 180, then the backside form comes into view and the front form disapears
Please how do I disable all other tables and forms from opening until the User is logged on. Secondly how do I make the password display asterisks(*) instead of the number like you did in this Video. I am presently creating an access front end for my sql server database and I really need this. Do you also have a video n how to do this in Macro?
S.I. CIMTHOG I highly recommend you watch my beginner series. I cover all of that in the series. ua-cam.com/play/PLYMOUCVo86jEeMMdaaq03jQ_t9nFV737s.html
I really enjoy your tutorials, but i have one question about this video. when we've got all the coding done and our activitylog is done. when you open up the database and get the login in screen, if you then decide not to login, but to close the database without login in, you'll get a empty activity log with no username but tagged as "logoff" in the "Activity" field. how can i work this problem out?
Is it possible to save an activity as described in the following example: My login activity will be recorded. Then I will open the case named as 354-CG/17. I will change something and log off. So that the activity records will be: t.s /Time/ logged in t.s /Time/ Saved file 354-CG/17 t.s /Time/ logged off If yes, how to achieve it? Thank you in advance!
how can i enter the windows username in the records with every data enter, not as a log in as a recored lets say i have a table with a column username to record what user recorded which line?
Thanks for this works great until I setup an sql exp database and used the same details, do I have to change anything to get this to work in sql exp settings.
It should work the same with SQL. If you do linked tables, make sure you rename them though. They tend to include the schema name so you'd get dbo_mytable instead of just mytable.
Nice sir,Sir i have 1 question.How i can ms access trial restriction from.Example: 6 month trial software/from access or 1 year access limited.please sir upload video on my topics.
Sir,I mean.How can I make my access database into a trial(How to make a trial version ) version as demo version for the client before distributing the full version (for example: I want the database will be shutdown or locked up automatically after 30 days).Such as AVG OR other antivirus trial system etc.I think now u understand sir.Thanks for replay sir. :)
Can you create this Activity Log without using SQL? I'm familiar with creating tables, queries, forms, etc... just not able to do coding type stuff. Please help??? {Thank you!}
Are you still monitoring these posts. I did everything as you stated in the video but I am getting a compile error when I run the logon. It states that the arguments are required. I currently have globals.logging "logon" and it continues to give me the error. Any suggestion?
I found your tutorial extremely helpful. However, I have google search high and low and I am not able to find the information I need. You have User tracking on Login and Logout. However, I would like to take it one step further : When the user enters data on a form and click on next or New Record, I would like the user name and date/time stamp on that record he/she entered. Can you direct me on any relevant video tutorial that would help me out?
Sorry I posted into the wrong video .Hello Steve, I have follow your steps and a Compile error: Argument Not Optional appears highlighting the Logging Global after I login again. Will you know why?
Hi! i was able to get my table to log the "logon" activity and "logoff" with the time.. however, i cant seem to be able to get the Username to come up... any suggestions on what i can possible be doing wrong?
try using/saving the string value generated by using the function Environ("USERNAME").Properties list: msdn.microsoft.com/en-us/library/system.environment(v=vs.110).aspx
Hi mate! How would i go about logging when a query has been run? so instead of logon being in the activity i would like the name of the query that the user has run? thanks!
Use the code that initiates the query. So if it's a button someone clicks or a drop down, maybe when a form opens. You cannot log anything that cannot be raised as an event in VBA.
Good afternoon SteveI have done the Login in screen. I have a form that the users input information, at the end of each record they choose their name letting me know who entered the record. I would like it when the login button is clicked it brings up all the records of the user name from the login form and it will also automatically enter the name of the user that is creating new records? I have gone thru the video's and can't find what I'm looking for.. Can you let me know where to look or how to do this?
+Nanette Hughes When the user first logs in, I suggest you store their name in the TempVars collection or a public variable. Then when that user creates a new record through the front end that they're logged into, you can just add that name to the data in the table.
Running CurrentDb.Execute avoids having to turn warnings off and back on. There's obviously some technical differences, but that's the reason I prefer using it.
you'll run out of numbers if you use the long number type?? Let's see, on the +ve side, long is just over 2.147 billion, and uses 4 bytes per, so that's 8 Gb of storage, but the whole db size limit is 2 Gb (as is the table size limit). A replication ID on the other hand, takes 16 bytes of storage per, so you ought to be able to store 1/4 of the numbers that you can by using Long. It should follow then, that you could only create 1/4 of the records using replication id that you could using Long, which you can't use all of anyway. Am I missing something?
Thanks, but I am not asking about that. What I am asking is when I login it will open main form after that I open another form and from that form I want to logout and want go to log in form. How could I do?
Hi Steve, Thanks for adding these types of video which support us to build the database. I would like to check with you with vba coding which is done in access for the login.I would like to make one of the criteria as read only, which i am not able to do with these code. Below are my code which i gave for my database. Private Sub Command1_Click() Dim UserLevel As Integer If IsNull(Me.txtLoginID) Then MsgBox "Please enter LoginID", vbInformation, "LoginID Required" Me.txtLoginID.SetFocus ElseIf IsNull(Me.txtPassword) Then MsgBox "Please enter password", vbInformation, "Password Required" Me.txtPassword.SetFocus Else 'process the job If (IsNull(DLookup("UserLogin", "tblUser", "UserLogin ='" & Me.txtLoginID.Value & "'"))) Or _ (IsNull(DLookup("password", "tblUser", "Password ='" & Me.txtPassword.Value & "'"))) Then MsgBox "Incorrect LoginID or Password" Else UserLevel = DLookup("UserSecurity", "tblUser", "UserLogin = '" & Me.txtLoginID.Value & "'") DoCmd.Close If UserLevel = 1 Then 'MsgBox "LoginID and Password correct" DoCmd.OpenForm "Navigation Form" Else If UserLevel = 2 Then (I need to add UserLevel - 2 as read only) 'MsgBox "LoginID and Password correct" DoCmd.OpenForm "Security_DS" End If End If End If End If End Sub Please suggest for some actions to resolve the issue.
hi, I subscribed to your channel and enjoy all the content. Also, I sent E-mail that asking for your help te set such a setting in my access database. hope to help me with my access database project.
ive been trying to save a label but it wont work it resets every time i push the load button?? this is my script: load button: lbl_cash.Text = My.Settings.Savecash lbl_cps.Text = My.Settings.Savecps Save button: My.Settings.Savecash = lbl_cash.Text My.Settings.Savecps = lbl_cps.Text
1st off wtf windows sucks stick to linux web server Account Activity Log using mysqli and php and 2nd make it 2020 versiopon that a client can see and report if ip is not there own real ip!
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.
Wow. I am so glad to hear that I have been able to help you and your company. It is amazing what a little bit of well applied knowledge can do.
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.
I think it would have taken me three lifetimes to do this on my own. THANK YOU! GOD BLESS YOU!
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.
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.
Steve bishop you are a saint. You have helped get a promotion at work!
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!
***** Thank you for taking the time to watch them!
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 & " ', ' " & TempVars("ProjectNameID").Value & " ',' " & Activity & " ')". Perfection!!!!!
+Ronda Ficklin I'm so glad to hear it helped.
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.
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!
You're welcome!
ɷɷ Youu Wonttt Beliveee Guysss Howwww I Losttt Fatt Fasttt In Justtt 3 Weeksss Withh Thissss Weight Loss Diet Visitt : - t.co/qKKnXk09RW
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
Crispy2012A That is a very specific request that requires intimate knowledge of the database you are working out of. Afraid that makes it difficult to do.
Crispy2012A I could do this for you. Please contact me at khanley at consultids dot com if you're interested.
What a wonderful video Steeve. You are a legend!
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.
Thanks Steve for sharing and preparing this video with us it's very easy to understand it 😎😎
I am so glad you enjoyed it. Unfortunately there was a little trouble syncing the audio with the video. Something happened to the desktop recording software.
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
Perfect Job Mr. Steve, Could you please share the link of "How to" playlist
Great work, Thanks
- Questions please:- How we can log & track other opened form on the same activity table?
Thanks in advance ..
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.
When it comes to tables, you cannot log changes unless you use macros. You are better off logging changes through the forms. If your users are able to access data directly in the tables, then you have a very serious security issue. Users should NEVER be able to open tables directly.
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
Well if you are logging to a table you can use that table in a report.
@@ProgrammingMadeEZ yes i did it, you are my new hero ! Thanks
Thanks for such nice videos, i loved your videos.
I have question for multiuser login system.
1. Created user registration form, any user can register by his own. By New user. Once his registration is complete, he can login.
2. Bu for this I want user ID (login ID) for login purpose but not the actual name of any user. So I created query to create "User Name"(login ID) by using user First and last name
3. Now I want use that "User name" /"login ID for the login form.
Dont know how to connect that, because my user name is existing in query (userExtended) but not in User Table. So that user can login with loginID.
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
Hi Steve, are you able to create a tutorial on how to log changes to records (indicating changes made, user info, & date-time stamp? I really hope you can.. thanks a bunch!
If you are just allowing people to modify data directly in a table or query, then there is no way to record log activity. If that is the case, then I HIGHLY recommend you stop. Giving people direct access to the data is a recipe for disaster. You should only allow people to use forms and reports. Then you have the advantage of coding the UI with VBA and hence log all changes using the method in this video, and that would include record changes.
Thanks for the videos. They really help. Can you create a video showing how to automatically backup a database using VBA code every time the database is opened?
+safaria12 have you seen this solution? mybusinessdatabase.com/vba-code-to-backup-an-access-database/
really easy to understand many thanks
can you please make examples on how to add more details like Computer Name, Windows logon, you talked about that but i like to see examples.
cheers
+Mohammed Arslan I suggest you watch the video in my basic series where I cover the environment variables.
This is a excellent series.
Hi Steve. Thank you for the videos.
Can you clarify which timezone timestamp will be captured if the backend and frontend are in different timezones.
Sham Kasturi Since the table is automatically filling in the date and time, it's going to be where the table is located. You could change that by changing the value in the recordset from the front end with now() in VBA.
Great tutorial! Thanks so much. I am already tracking user additions and modifications to tables, but this will add to the information my client wishes to gather.
Is there a simple way to track when a user runs a report, if that report is a button on the dashboard? Would you put the code in the dashboard form or in the On Load report form, or would either work?
Once again, thanks! I'm definitely going to check out your other videos as I'm sure I could learn a lot.
Kerry Hanley Either works.
Hi there, Great video tutorial. I am getting a compile error: Argument not optional on Logon & Logoff. I am trying to add environment variables to retrieve the Windows UserName and WorkstationName and enter into the logging table. Could you please advise how to resolve this. Thanks
Hi Steve. Great tutorial! I also need to track the changes made on other forms in my db. Do you have another tutorial regarding tracking these changes?
+shezgill Why can't you use the same function everywhere? That's what it was built to do.
+Programming I am new to programming and I don't know how this function would give me the value that was changed and what the value was changed to using this code. To me it seems like it will give you whatever message that you tell it to give you when the data is changed. Again, I am sorry for not understanding, I am new to coding.
+shezgill I'm afraid any How To video I do requires you to at least know the basics of Access development. If you're interested I have a basic series on my channel.
+Programming I've seen your videos and they are great. I haven't seen any help regarding what I need but thank you for your videos. They are still some of the best that I've seen.
+shezgill I understand that none of my video's specifically cover your question, but what you are looking to do requires that you know how to watch for event that happen in your database (which I cover in the basic series), then call this function with the proper arguments (which I cover in the basic series). I'm afraid after that it's a matter of you being able to piece together the bits of knowledge to come to your own solution. That's what programming is all about!
amazing tutorial thanks a lot SIR!
Great tutorial, I was also wondering if there is a way to track the total time spend logged in by a user over a month
Thanks heaps anyway.
+garantina101 Sure, just make your text you pass in have some sort of indication that the action was a login or logoff action. Then write up some queries to total up the difference between those two actions.
Be careful though, if someone just exits the application via taskmanager or hitting the close button it won't trigger an event. I suggest you make sure the close button (X in the upper right corner of the window) is not available.
+Programming Thanks heaps, worked great!
Hello Steve! Thanks again for all your help. I've got a wee touch of a conundrum, and am hoping you can get with a syntax issue. it may not even be possible to do what I'm trying to work out. I've got everything set up the way you've suggested above, and it works beautifully. Yay!I'd like to pass as one of the TempVars the name of the form that the user is currently on before they leave the form for the next form. How would I write that particular bit of code for the TempVar? I tried TempVars("FormName").Value = Forms!Loginwith the thought that I could change the form name portion for each page, as there are only 9 pages total. But then I had several thoughts - a) the db is likely to grow making it quickly become unruly; b) that particular reference will not work as TempVars prefer to look at data and not datasets; c) I could Dimension the form name as a string and then reference it after the = as such, but that would likely have negative repercussions as the form is being used as a form object at the time it is being Dimensioned as a string, creating an internal conflict.So I am left with zilch ideas. Is there an easier way to pass the current form name into the TempVars? Thank you again!
I'm not sure why you can't just set a TempVars("LastForm") when the form is deactivated. You could also have a TempVars("CurrentForm") value set when the form is loaded so you are keeping track of both the last form and the current one.
Never heard of either one, didn't know what to look for, now you've given me not one but two options and I KNOW you are the best - WOOT!!!!!!! (And talk about Speedy Gonzalez on that reply!)
Wait, I got so excited I completely forgot, my original question still remains, what comes after the equal sign? How do I refer to the form name without actually calling the form? TempVars("CurrentForm") = _________ ?
Tammy Bergen Well if you're executing the code from the module behind the form, then you can get the form name by just doing me.name. So TempVars("CurrentForm") = Me.Name
It works! Thank you so very much, you are a blessing - truly!
Hi Steve,
i am struggling with the logout part. I did this exactly like you and placed the logout part in the form_Unload event. If i use the X button on top of the Acces application form it works as expected.
If i use a button with a Docmd.quit that i placed on my Menue form it doesn`t write the logout? Strange, huh? Hope that`s not a bug in the 2016 version of ACCESS.
Anyway thanks so much for your great channel. Much appreciated!
Try calling the code just before your docmd.quit from your menu form.
Hello,
thanks for the idea. It`s working perfectly now.
I got this to work after a bit of trouble shooting. I was placing the code to call the function in the wrong place in the VBA code for the "Login" button. It needs to be right before the "End Sub" line.I now have a couple of questions. Firstly, I opened the log this morning to track user activity and found several records with no username, just blank. But there were records for all the known users I was expecting to see. Any ideas on how these could have been generated? I expect that it could be from failed logins. If that is the case could I run the table through a query with an "Is Not Null" parameter on the username field. ??Another question. How can I generate a list of "Currently logged-in Users"? Is there a way of specifying users who have logged in but not yet logged out? Maybe something line a count of users that are uneven indicating logged in but no matching log out?
Hi Steve, is it possible to add in how users able to reset their own password? and do you have tutorial vids on how to create user's page and from that page we could see their activities or history maybe
Frizzell Abas Hmmm... that's pretty specific but probably useful. I'll see what I can do.
Hi Steve :
and thanks a lot for the nice videos , Is there any way I can track all the changes that were made by specific user in a specific record ? .
thanks in advance .
It depends on how you are allowing the user to interact with the record. If you use recordsets in VBA it will give you an opportunity to use the function from this video.
Programming
thanks Mr Steve.
actually all what i need is to know when and who have created a specific record and if it was updated then I well get when it was updated and by whom ? I have seen your video 53 and i believe it is so close but I couldn't make it ..
SD QATAR When someone adds a new record to the recordset, run this function. Then you will be storing the info to the logging.
can you please link where did you create the TempVars in your video? i'm programming in c# what is the equal function of the tempvars?
Tempvars is built into Access. I didn't create it.
Hello Steve. I'm enjoying your video's I find them helpful and easy to follow. I am setting up an employee time db. They will be entering a Project No and the amount of time spent on it. I have created a form that is filled out by an administrator, it has USER NAME, PRODUCT LINE, START DATE and END DATEI would like all this information to be added to a report that I have already created. I have also created your login form. How do I go about doing this?Thank you for your timeNanette
+Nanette Hughes Have you watched my basic and advanced series? I cover how to do all of this.
I have utilized your expertise from this video. Thank you. However, when I eventually split the database and saved the two ends in separate folders (I did update the table link manager to access the proper back end file) my users, not me, are receiving an "On Click" error code that leads me to believe there is something not converting from your prescribed VB coding for the event. Any words of wisdom on this?
Unless you have forgotten to link the table containing the access levels, it should work the same as it has.
great channel but how i can create the audit trailer on form with combobox?
You just call the function for every action you want to track. So if it's when the user makes a change on a combo box you call the function on the change.
love your videos!!! great stufff...
Sir, Is it possible to upload a video for Access Form to be display only Login Users Relevant Data in Any Form
Hello Mr. Steve. Great video. Question. At 16:20 in the video, you created a globals to pull the logging function. I cannot get my code to do the same. I repeated your code but I still get error. Any ideas?
+Brahmablu I'm sorry but I don't have any way of diagnosing the problem as you've presented it.
+Programming it's okay. I figured it out. Global is the name of your module. I thought it was a built in Access function. My module is named GetLogIn. once I made the change, it worked perfectly. I'm new to programming. Thanks again for the video!!!
Good to hear!
Hello Steve, thank you for your videos.
I have a splitted db without login process. It located in a network folder. I need to know how to disconnect all users from the db to implement my updates. The file is locked while in use.
How do I manually disconnect users from an access db?
It's a bad idea in general to disconnect users if they still have data open in their front ends. I would suggest waiting until everyone is done rather than trying to force them off. You will likely cause some data corruption if you do.
Yes, I agree it's bad idea to do this without notifications of users and saves. But for example someone left the db open on the weekend or till next day and I strongly need to do my updates. I can't wait so long. It would be nice if you made a video how to notify an user of front end that maintenance of the db is required. If user not responds, it will save data automatically and close access application. I think many of developers will tell you "Thank you so much !"
There is no simple way to do this, nor a fool proof one either. I suggest moving to SQL Server where this is no only capable of being done, but is built right into SQL Server.
+Programming Thank you for your reply.
I would like to know how you track windows Login In Name. that would be incredibly helpful.
How to add record id to activity , to track which record changed or update
Hi Steve, love this function to monitor activity.
Now i want to monitor changes to a record and found a way (using this video) to get an activity logged when a field is changed.
But i want to see witch record were changed of the field, is there a way to get the recordID with this changed field ?
(hope i make any sense in my question) :-)
+RichBu22 Unfortunately the function can only be called from within VBA. Since table data changes themselves do not trigger any events we cannot capture changes when data is changed. What you can do is capture the change on a textbox though. So if you display the data on a form and the user can change it there, you should be able to use this function to record that.
Ok, solves it with another TempVars like the username. How much room is there to use tempvars ? Could i use it to store a memo field in it ?
You can store anything you like but just be careful, it's memory and the more of it you use up the slower the performance you might see.
Ok, thanks for the help and the awesome video's !!
Steve, haven't been able to find an instructional video on how to transition a form that rotates on it's horizontal access i.e. form turns counterclockwise and then reveals the sequential form on the backside. Surprised there is not a lot out there in Access that takes advantage of the visuals that PowerPoint has for transition options....I've seen it on the web, but unclear how it's done...possible for you to create the video?
John Vage Do you have a video that shows what you're talking about? I'm having trouble picturing it.
Programming Can't find it now, but think about a piece of paper you are holding upright and then turn the page to see the backside...the First form on front, second form on back. When the form has turned 180, then the backside form comes into view and the front form disapears
Please how do I disable all other tables and forms from opening until the User is logged on. Secondly how do I make the password display asterisks(*) instead of the number like you did in this Video. I am presently creating an access front end for my sql server database and I really need this. Do you also have a video n how to do this in Macro?
S.I. CIMTHOG I highly recommend you watch my beginner series. I cover all of that in the series.
ua-cam.com/play/PLYMOUCVo86jEeMMdaaq03jQ_t9nFV737s.html
I really enjoy your tutorials, but i have one question about this video. when we've got all the coding done and our activitylog is done. when you open up the database and get the login in screen, if you then decide not to login, but to close the database without login in, you'll get a empty activity log with no username but tagged as "logoff" in the "Activity" field. how can i work this problem out?
+ace vfx Perhaps do an if statement to see if the user is blank before logging it?
Is it possible to save an activity as described in the following example:
My login activity will be recorded. Then I will open the case named as 354-CG/17.
I will change something and log off. So that the activity records will be:
t.s /Time/ logged in
t.s /Time/ Saved file 354-CG/17
t.s /Time/ logged off
If yes, how to achieve it? Thank you in advance!
how can i enter the windows username in the records with every data enter, not as a log in as a recored lets say i have a table with a column username to record what user recorded which line?
Excelent, tks a lot
Its a nice tutorial i loved it
Thank you!
Thanks for this works great until I setup an sql exp database and used the same details, do I have to change anything to get this to work in sql exp settings.
It should work the same with SQL. If you do linked tables, make sure you rename them though. They tend to include the schema name so you'd get dbo_mytable instead of just mytable.
I change it back to dbo and it worked, thanks
Thank you very much.
Do you have code similar to this one but made using vb.Net?
Nice sir,Sir i have 1 question.How i can ms access trial restriction from.Example: 6 month trial software/from access or 1 year access limited.please sir upload video on my topics.
Buy it.
Sir,I mean.How can I make my access database into a trial(How to make a trial version ) version as demo version for the client before distributing the full version (for example: I want the database will be shutdown or locked up automatically after 30 days).Such as AVG OR other antivirus trial system etc.I think now u understand sir.Thanks for replay sir. :)
That's too complex to answer in the comments. I might make up some sort of video on a way to do it.
Thanks a lot sir.I will wait for your video.If you upload very soon thats helpful for me.
Can you create this Activity Log without using SQL? I'm familiar with creating tables, queries, forms, etc... just not able to do coding type stuff. Please help??? {Thank you!}
Hi Steve
Can I add greeting message to the user once he logged successfully?
Sure. Just add a msgbox line greeting them after they've passed validation.
Are you still monitoring these posts. I did everything as you stated in the video but I am getting a compile error when I run the logon. It states that the arguments are required. I currently have globals.logging "logon" and it continues to give me the error. Any suggestion?
Steve,
I am trying to down load the work files. The be database saves fine; however, I cannot save the fe file. Help!
I found your tutorial extremely helpful. However, I have google search high and low and I am not able to find the information I need.
You have User tracking on Login and Logout. However, I would like to take it one step further :
When the user enters data on a form and click on next or New Record, I would like the user name and date/time stamp on that record he/she entered.
Can you direct me on any relevant video tutorial that would help me out?
You would have to use macros for table changes.
Thanks
is there any way to know about in which computer my access file has been created and edited, if it is edited in other pc, please help me
Sorry I posted into the wrong video .Hello Steve, I have follow your steps and a Compile error: Argument Not Optional appears highlighting the Logging Global after I login again. Will you know why?
No idea. Try comparing what you've done with what's in the work files.
Hi! i was able to get my table to log the "logon" activity and "logoff" with the time.. however, i cant seem to be able to get the Username to come up... any suggestions on what i can possible be doing wrong?
I have the same issue. Did you figure it out?
I had the same issue. i was missing this in the Button Login TempVars("UserName").Value = Me.txtusername.Value
try using/saving the string value generated by using the function Environ("USERNAME").Properties list: msdn.microsoft.com/en-us/library/system.environment(v=vs.110).aspx
Excelente
how do you log winlog users that are not in your user list (guest users)?
Hi mate!
How would i go about logging when a query has been run? so instead of logon being in the activity i would like the name of the query that the user has run?
thanks!
Use the code that initiates the query. So if it's a button someone clicks or a drop down, maybe when a form opens. You cannot log anything that cannot be raised as an event in VBA.
That's great, Can you help me log when a user clicks anything within a custom tab? Cheers!
Good afternoon SteveI have done the Login in screen. I have a form that the users input information, at the end of each record they choose their name letting me know who entered the record. I would like it when the login button is clicked it brings up all the records of the user name from the login form and it will also automatically enter the name of the user that is creating new records? I have gone thru the video's and can't find what I'm looking for.. Can you let me know where to look or how to do this?
+Nanette Hughes leaving a comment incase someone replies.
+Nanette Hughes When the user first logs in, I suggest you store their name in the TempVars collection or a public variable. Then when that user creates a new record through the front end that they're logged into, you can just add that name to the data in the table.
Whats's the difference between CurrentDb.Execute and DoCmd.RunSQL ?
Running CurrentDb.Execute avoids having to turn warnings off and back on. There's obviously some technical differences, but that's the reason I prefer using it.
Programming ok, thanks
p.s. nice videos and an incredible fast answer
you'll run out of numbers if you use the long number type?? Let's see, on the +ve side, long is just over 2.147 billion, and uses 4 bytes per, so that's 8 Gb of storage, but the whole db size limit is 2 Gb (as is the table size limit). A replication ID on the other hand, takes 16 bytes of storage per, so you ought to be able to store 1/4 of the numbers that you can by using Long. It should follow then, that you could only create 1/4 of the records using replication id that you could using Long, which you can't use all of anyway. Am I missing something?
Help! My table isn't populated with the user name every log in. Its sporadic and I can't figure out why.
when we open two or more form in background how to close those form in one click without quit application?
There should be an grey X in the upper right corner below the red X that closes the application.
Thanks, but I am not asking about that.
What I am asking is when I login it will open main form after that I open another form and from that form I want to logout and want go to log in form. How could I do?
Nilkantha Neupane You can make the form visible again by setting the .visible property back to true.
Is that means no code I need to add?
Thanks
I don't understand your question.
I get an error when type Globals.logging "Logon". Compile error: Argument not optional. and same error for "Logoff"
Hi Steve,
Thanks for adding these types of video which support us to build the database.
I would like to check with you with vba coding which is done in access for the login.I would like to make one of the criteria as read only, which i am not able to do with these code.
Below are my code which i gave for my database.
Private Sub Command1_Click()
Dim UserLevel As Integer
If IsNull(Me.txtLoginID) Then
MsgBox "Please enter LoginID", vbInformation, "LoginID Required"
Me.txtLoginID.SetFocus
ElseIf IsNull(Me.txtPassword) Then
MsgBox "Please enter password", vbInformation, "Password Required"
Me.txtPassword.SetFocus
Else
'process the job
If (IsNull(DLookup("UserLogin", "tblUser", "UserLogin ='" & Me.txtLoginID.Value & "'"))) Or _
(IsNull(DLookup("password", "tblUser", "Password ='" & Me.txtPassword.Value & "'"))) Then
MsgBox "Incorrect LoginID or Password"
Else
UserLevel = DLookup("UserSecurity", "tblUser", "UserLogin = '" & Me.txtLoginID.Value & "'")
DoCmd.Close
If UserLevel = 1 Then
'MsgBox "LoginID and Password correct"
DoCmd.OpenForm "Navigation Form"
Else
If UserLevel = 2 Then (I need to add UserLevel - 2 as read only)
'MsgBox "LoginID and Password correct"
DoCmd.OpenForm "Security_DS"
End If
End If
End If
End If
End Sub
Please suggest for some actions to resolve the issue.
+Fazil Oleed have you watched my login screen video in the basic series? There is a work file you can compare your code to.
hi, I subscribed to your channel and enjoy all the content.
Also, I sent E-mail that asking for your help te set such a setting in my access database.
hope to help me with my access database project.
Hi steve I mean if my user logins he will receive a welcome message with his name
thanks
You can put:
msgbox ""
When the user passes validation. I don't quite understand how that relates to the topic of the video though.
goooodddd
Will this work in a multi-user environment?
+J Man Yup
ive been trying to save a label but it wont work it resets every time i push the load button?? this is my script:
load button:
lbl_cash.Text = My.Settings.Savecash
lbl_cps.Text = My.Settings.Savecps
Save button:
My.Settings.Savecash = lbl_cash.Text
My.Settings.Savecps = lbl_cps.Text
+Plaha I'm afraid this isn't enough information to diagnose the problem with.
Mr. Steve. .how I add computer name
+Asad Aqeel Use Environ$("computername")
+Programming thanks ,it's done.
+Programming , do you have this tracking feature explained on any of your videos ?
+Daniel Rodriguez That's what this video is about. How to log the activity of your users.
what about in 2010?
I encounter compile error
Service Inc_fe .can you tell me username and password
1st off wtf windows sucks stick to linux web server Account Activity Log using mysqli and php and 2nd make it 2020 versiopon that a client can see and report if ip is not there own real ip!