Very insightful, well stated, and easy to follow. You are a gifted teacher! Thank you! I was praying to find an answer on how to accomplish this task and after many hours of reviewing other solutions, I came across your video. You/your video was the perfect answer that I needed. Thank you!
This video deserves over a million views.. great job! It was so easy to understand compared to the hundreds of other videos Ive seen recently. Thank you.
Another great video! During testing, I use an environment where the actual user impersonates another user with a different level of permissions. So, in my case, I have a function called MyEnviron() that wraps Environ(). If we are testing, MyEnviron returns something other than the real user. So one can see the value of wrappers. If I had written Environ("UserName") in the form config, the test would fail.
After logging the Windows user is there a step by step to create user permissions to what the Windows user can access? There are UA-cam videos on creating User Permissions but not based on the Windows User, they are based on a user list created in the database, which requires a user login screen. Because of logging the Windows user I don’t need the user login screen in the database
You would continue very much like any login dialog base solution. However, as you use the Windows login you do not use the login dialog to identify the user.
Great video sir. I have been looking to do this exact thing in my access database. I have a question though, I created my database in access 2010 and had a text box showing the name of the person's login on the main screen now after opening it in office 365 I can't get the info to show up. I've check and all I can find is environ ("username") but I don't want the system name I want the user name based on the login. Thanks in advance.
Do I understand correctly, you want to display the Office 365 user name? - That is a very good question. - Unfortunately I cannot answer it right now. There seems to be no straight forward way to get to this information. I will reseach this and try to find a solution, but this may take time.
codekabinett.com/en thanks for your reply. I have a table within my database with the names of the users, their username and password. In office 2010 I was able to show the name of the current user based on their username for the database and not the user (environ) name of the computer user
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.
This all should work in AccDE the same. Have you got any details on how exactly it does not work? Maybe there are security settings preventing the execution of VBA code. Can you put the AccDE in a trusted location?
You need to provide more information on how exactly it does not work. Long shot: Maybe macros and VBA code are disable in Access for the users where it does not work?
@@codekabinettcomen thank you for the reply. Turns out users were just hiting the do not trust warnings when opening. Thank you again for the video, works perfectly!
You can use the GetUserName function I showed in the video in a query. - If you cannot use any VBA at all, you're probably out of luck. The built-in Environ function is blocked from direct use in queries.
Good video - can anyone give us a tip to update user info on import multiple records (from excel) into access - I only get one record updating my user when I import multiple records. The date/time's for all records update as expected - user name on the first record only
I would think about linking the Excel sheet in a query (Keyword: IN (docs.microsoft.com/en-us/office/vba/access/concepts/miscellaneous/in-clause-microsoft-access-sql)) and the doing the actual import with an append query from linked sheet to the target table. In that append query you can add all sorts of information, like the user name.
@@codekabinettcomen Kindly can you show Function in SQL for MS access Query that show Windows Username? I used CurrentUser() but I got "Admin" it does not show my UserName in windows. so do you have any helpful function for query. Thanks
Very insightful, well stated, and easy to follow. You are a gifted teacher! Thank you! I was praying to find an answer on how to accomplish this task and after many hours of reviewing other solutions, I came across your video. You/your video was the perfect answer that I needed. Thank you!
You have no idea how happy this made me:) thanks kab
This video deserves over a million views.. great job! It was so easy to understand compared to the hundreds of other videos Ive seen recently. Thank you.
Superb video sir.. Excellent! Thank you so much!
This video is the answer to my prayers! Thanks a lot!
I not only "Like" this video, I love it! Thank you... Hope you find some time to teach us some more!! VIELEN DANK!
Just what I needed, thanks for making the video.
Another great video!
During testing, I use an environment where the actual user impersonates another user with a different level of permissions. So, in my case, I have a function called MyEnviron() that wraps Environ(). If we are testing, MyEnviron returns something other than the real user. So one can see the value of wrappers. If I had written Environ("UserName") in the form config, the test would fail.
ohh! Very easy way 👌 and very good.
Perfect simplicity! Worked for me on the first try! A meeeeeeeeeeeeeellion thank yous.
Thank you sir. This what im looking for.
You are awesome. Thank you for this video. this is very helpful
Nice. Your videos are really cool.
Thanks a lot, this will help track progress through my databases. Fantastic.
After logging the Windows user is there a step by step to create user permissions to what the Windows user can access? There are UA-cam videos on creating User Permissions but not based on the Windows User, they are based on a user list created in the database, which requires a user login screen. Because of logging the Windows user I don’t need the user login screen in the database
You would continue very much like any login dialog base solution. However, as you use the Windows login you do not use the login dialog to identify the user.
@@codekabinettcomen Well I am very much interested in your version as I chose this video and was able to complete it.
For some reason, despite following all of the steps, this doesn't work for me. It auto-populates the box with "#Name?".
Any solutions? Thanks!
The #Name display usually is caused by a misspelled control or function name in the controlsource of the textbox.
Great video sir. I have been looking to do this exact thing in my access database. I have a question though, I created my database in access 2010 and had a text box showing the name of the person's login on the main screen now after opening it in office 365 I can't get the info to show up. I've check and all I can find is environ ("username") but I don't want the system name I want the user name based on the login. Thanks in advance.
Do I understand correctly, you want to display the Office 365 user name? - That is a very good question. - Unfortunately I cannot answer it right now. There seems to be no straight forward way to get to this information. I will reseach this and try to find a solution, but this may take time.
codekabinett.com/en thanks for your reply. I have a table within my database with the names of the users, their username and password. In office 2010 I was able to show the name of the current user based on their username for the database and not the user (environ) name of the computer user
Thanks a lot, it's very Fantastic
Thank You For This Tutorial
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.
This seems to be a design problem. If the two tables/queries are related, there has to be an attribute to link them together.
It works perfectly for an .accdb, but not for an .accde. Are there any other possibilities for an .accde?
This all should work in AccDE the same. Have you got any details on how exactly it does not work?
Maybe there are security settings preventing the execution of VBA code. Can you put the AccDE in a trusted location?
Danke danke danke Philipp
very good solution! works - but a little bit too long e.g. name conventions for txt fields...
Wonderful video...really deserve more views. Cool.... subscribed. expecting more...\
Thank you so much for this video! It works for some of my users, but not all. Any suggestion what to do/check to resolve this?
You need to provide more information on how exactly it does not work.
Long shot: Maybe macros and VBA code are disable in Access for the users where it does not work?
@@codekabinettcomen thank you for the reply. Turns out users were just hiting the do not trust warnings when opening. Thank you again for the video, works perfectly!
Thank you
Kindly can you show us how to do it by Microsoft Access query design maybe by (SQL)
You can use the GetUserName function I showed in the video in a query. - If you cannot use any VBA at all, you're probably out of luck. The built-in Environ function is blocked from direct use in queries.
Good video - can anyone give us a tip to update user info on import multiple records (from excel) into access - I only get one record updating my user when I import multiple records. The date/time's for all records update as expected - user name on the first record only
I would think about linking the Excel sheet in a query (Keyword: IN (docs.microsoft.com/en-us/office/vba/access/concepts/miscellaneous/in-clause-microsoft-access-sql)) and the doing the actual import with an append query from linked sheet to the target table. In that append query you can add all sorts of information, like the user name.
Genius
Thanks Thanks Thanks Thanks Thanks
Thanks Thanks Thanks Thanks Thanks
Thanks
Kindly can you show us how to make History table?
I'll think about the history table. I've done that only with Sql Server so far...
@@codekabinettcomen Kindly can you show Function in SQL for MS access Query that show Windows Username? I used CurrentUser() but I got "Admin" it does not show my UserName in windows. so do you have any helpful function for query. Thanks
@@codekabinettcomen Can we insert the VBA Module in Tables instead of Forms?
@@ssdusd , no you cant. But can use the datasheet view of a form. That looks like a table but has options to customize user interaction with VBA.
@@codekabinettcomen Kindly can you show us how to do it in Query instead of forms? Plz!
My VBA is blocked, so kindly can you do it in Macros and show us. Plz
I'm not sure. I don't use macros at all and doing a video on them is currently not on my agenda.
Thank you for the feedback nonetheless.