How to create Multi User LOGIN FORM in Ms Access With SECURITY LEVEL | Part-3

Part 1: • How to create Multi Us...
Part 2: • How to create Multi Us...
Downloadable Templates:
• Free Download Template
Please Like and Subscribe for more video 🙏
KEYWORD:
How to create login form in microsoft access,
Login form in microsoft access with credentials,
How to create login form in microsoft access with security label,
How to appear username in dashboard,
How to create a temporary login in microsoft access,
Microsoft access login form tutorial,
microsoft access tutorial for beginners,
microsoft access database tutorial,
microsoft access 2019,
microsoft access toturing,
microsoft access tutorial,
microsoft access tutorial for beginners,
software design tutorial,
database design tutorial,
#microsoftaccess
#MsAccessLogin
#microsoftaccesstutorial

[@moh.3sam]

It's a great pleasure to have you here.
How may I get this system to uses

[@mehdiberisha114]

comment on peut afficher un photo avec une liste déroulant avec microsoft access? merci beaucoup pour votre compréhension

[@krprasad7519]

Hi,
For audit purpose the data of the table is upended to another table when any of the records in a form are changed or added. Is there a way to add the username to the to the upended table against each records when the user changes the record or add new record.

[@EdcelleJohnGulfan]

Yes absolutely. You can use the After Update event function. In your table, just add username field. In your text box, write this:
Me.username = environ("username")
That's your computer's Username.

[@krprasad7519]

@@EdcelleJohnGulfan Thanks for your reply. How can I have the username which the user used to login the access program instead of computer login name. Is there a way to do this?

[@EdcelleJohnGulfan]

Just use temporary variable. If you have the username visible in your form.... instead of environ, you can type me.username = form![name Of Form]![textbox name of username]

[@Abdullah_Alhathloul]

Thanks 👏👏👏

[@EdcelleJohnGulfan]

You're welcome Abdullah

[@jbraun3043]

This is PERFERCT. I did not see how you configed the logout button. Did I miss that? Also, I want to config mine to close the logon page after the users login. Do you know how I would manage that?

[@Rojin.Marzooki]

i have question: how can I make the access open the login at start up and not show the background which show the tables and editing on access. Only show forms

[@EdcelleJohnGulfan]

Try this.
Hide the start up: ruclips.net/video/iuSWN_uVnL8/видео.html

[@EdcelleJohnGulfan]

Hide the ribbon or menu: ruclips.net/user/shorts_p1Ddn6DsjU?feature=share

[@ruppyjuntaripe6917]

Good day sir. kng level 2 po ma access pa rin po ba nya ang mga table?

[@EdcelleJohnGulfan]

Belong yan dito.
ruclips.net/video/Da2sCMub3nk/видео.html

[@PBCinCorpusChristi]

How would you populate a field in another form with the username?

[@EdcelleJohnGulfan]

ruclips.net/video/tJsjVKAM54Q/видео.html

[@EdcelleJohnGulfan]

and check in the 7:40

[@jeanronychavannes6828]

how much it,s cost

[@pauls8270]

Excellent work! Is your Database available for download please?

[@EdcelleJohnGulfan]

There are similar login form in my FREE TO DOWNLOAD PLAYLIST.

[@EdcelleJohnGulfan]

ruclips.net/p/PLxBRM3hoV3nPdnE3yKTztDD4bPmgOScJQ

[@pauls8270]

@@EdcelleJohnGulfan I've looked through the playlist, but did not find the detailed ones you demonstrate here.

[@CHKRuhunage]

How do you add new users? For example in the case with a new user

[@EdcelleJohnGulfan]

I have another form wherein I can add users.

[@santrehNgoding]

Sir... make a ms acces database tutorial sir... please....... thanks alots..

[@EdcelleJohnGulfan]

Many more to upload sir.

[@streetbasketball286]

Boss nag error ito 2465. bakit kaya
Forms![frm HOA Main Menu User]![UserName] = UCase(TempVarUserName)

[@EdcelleJohnGulfan]

Ano ang error message?

[@txujcihmoob88]

Very good system, How may I get this system to uses

[@EdcelleJohnGulfan]

Email me at [e-mail].

[@mengmanli1997]

Hi Sir Can I request a copy of your Access database? Thank you

[@EdcelleJohnGulfan]

ruclips.net/p/PLxBRM3hoV3nPdnE3yKTztDD4bPmgOScJQ

[@user-gu7uh6im2x]

hi i have been 6 hours at it to recheck everything and i noticed that betwenn your 3 part video a lot is not said and i am still getting «method or data member not found » i am getting rather anoyed really

[@EdcelleJohnGulfan]

If you got that error, it means that the name of field you are using does not exist. Smo check the spelling. Sometimes due to spelling.

[@user-gu7uh6im2x]

i was looking at another of your tutorials what i have found out is when the intellisence is presuming commands you have the SetFocus Command coming as a choice.... not me! missing library maybe? thank you for your time Sir
@@EdcelleJohnGulfan

[@sissokom.prodev9979]

There is security issues in the login form ! If the user type admin and enter any password in your table the form will login 😊

[@EdcelleJohnGulfan]

Sorry I forgot to add this lines.
Just find this lines.
Below the ELSE,
TempVarUsername.......
UserLevel......
TempPass.....
Id......
'Insert this code
IF ME.PASSWORD TEMPPASS THEN,
MSGBOX "INCORRECT PASSWORD",VBINFORMATION," LOGIN DENIED"
ME.USERNAME = ""
ME.PASSWORD =""
ME.USERNAME.SETFOCUS
ELSE

[@EdcelleJohnGulfan]

It's a great pleasure to have you here.

[@sissokom.prodev9979]

@@EdcelleJohnGulfan the quality of your video is excellent! :)

[@EdcelleJohnGulfan]

@@sissokom.prodev9979 I'm still learning. I like your coding also and your projects is very impressive.

[@txujcihmoob88]

good system, I would like to have it and have sent you email please let me know if possible to get it

[@BudiartoAriansyah]

I have followed everything, from tables and forms but why when I enter a different username but with the same password I can login.
example :
username = john; password = 123
username = edy; password =456
I use username "jhon" password "456" can still login

[@EdcelleJohnGulfan]

Sorry. I forgot to add lines for it.
Just find this lines.
Below the ELSE,
TempVarUsername.......
UserLevel......
TempPass.....
Id......
'Insert this code
IF ME.PASSWORD TEMPPASS THEN,
MSGBOX "INCORRECT PASSWORD",VBINFORMATION," LOGIN DENIED"
ME.USERNAME = ""
ME.PASSWORD =""
ME.USERNAME.SETFOCUS
ELSE

[@BudiartoAriansyah]

@@EdcelleJohnGulfan Thank you very much, my problem has been solved. waiting for your other useful videos 👍🙏

[@EdcelleJohnGulfan]

Thanks for watching Budiarto.