CREATE LOGIN FORM IN ACCESS USING MACRO EVENT!!

A Login form is used to enter authentication credentials to access a page or form. The login form contains a field for the username and another for the password. When the login form is submitted its given code checks that the credentials are authentic so that the user can access the page or form.
Channel link :
/ @primaleduworld
Facebook Page:
/ primaleduworld
Instagram:
/ primal_eduworld
login form in access using dcount and dlookup
ms access login form with password
ms access login form tutorial
ms access login screen
Design Login Form In Ms Access Database

Пікірлер: 121

  • @PrimalEduWorld
    @PrimalEduWorld3 жыл бұрын

    Follow us on Instagram: instagram.com/primal_eduworld/ Follow us on Facebook: facebook.com/primaleduworld/

  • @taslimtisekar6140
    @taslimtisekar6140 Жыл бұрын

    Very nice video..thank you for the upload 👍

  • @maysak3595
    @maysak35952 жыл бұрын

    This was very detailed info...thanx for sharing

  • @smttomar
    @smttomar2 жыл бұрын

    Nice informative video

  • @faizkhan4840
    @faizkhan48402 жыл бұрын

    Superb.. 👍

  • @sammenon7261
    @sammenon72612 жыл бұрын

    Lot of videos that I watched didn't make any sense , but when your video recommended for me I finally understood how to create a simple login . Thank you so much , ////////////////////

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thanks for visiting our channel, please watch our other videos, they are also very informative. 🙏

  • @aliakhan3278
    @aliakhan32782 жыл бұрын

    Thanks for sharing this video, today I learnt MS ACCESS almost everything.

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thank You 🙏

  • @anjanamishra5518
    @anjanamishra55182 жыл бұрын

    Thank for sharing this information ☺️

  • @tarakapadia7515
    @tarakapadia75152 жыл бұрын

    Nice video 👍

  • @catalinboronschi950
    @catalinboronschi9502 жыл бұрын

    Great video,Thank you 👍

  • @rheac4306
    @rheac43062 жыл бұрын

    Very informative video I have seen today, very well explained step by step.

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thanks 🙏

  • @AliAbbas-xq9dn
    @AliAbbas-xq9dn2 жыл бұрын

    Keep it up

  • @dkquicksupport
    @dkquicksupport2 жыл бұрын

    Waoo that's really very nice and informative

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thank you 🙏

  • @kantabamola5826
    @kantabamola58262 жыл бұрын

    Well explained

  • @superoshineproducts507
    @superoshineproducts5072 жыл бұрын

    Very nice

  • @mamagaming1575
    @mamagaming15752 жыл бұрын

    Great ur trips!

  • @danielmladin8486
    @danielmladin84862 жыл бұрын

    Thank you, good info

  • @AmitKumar-ym8kl
    @AmitKumar-ym8kl2 жыл бұрын

    Lovely

  • @zakwanjam
    @zakwanjam2 жыл бұрын

    Wonderfulllllllllllllllll!!!!!!!!!!!!!!!!!

  • @user-sh6tp4dj7l
    @user-sh6tp4dj7l2 жыл бұрын

    Thanks for sharing this information 💁‍♀️ ~~~

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thank You dear 🙏

  • @jacobmathew4
    @jacobmathew44 ай бұрын

    God presentation

  • @PrimalEduWorld

    @PrimalEduWorld

    4 ай бұрын

    Thank you

  • @lustoricgaming1565
    @lustoricgaming1565 Жыл бұрын

    Really Helped Me Out Thanks...

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Thanks for visiting our channel, please watch other videos they are more informative. Please like and subscribe to our channel and share to your friends and family members. Thanks 🙏

  • @trishamajumder7803
    @trishamajumder78032 жыл бұрын

    Great

  • @travelfar1845
    @travelfar18452 жыл бұрын

    Beautifully explained 👍

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thank you 🙂

  • @dishakiduniya1803
    @dishakiduniya18032 жыл бұрын

    Nice information keep it up 👍

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    We surely will!! And thanks ❤

  • @cindyrussell5963
    @cindyrussell5963 Жыл бұрын

    Thank you and will be looking forward to it

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Great!

  • @urdughazal1748
    @urdughazal17482 жыл бұрын

    Good

  • @amanu78
    @amanu78 Жыл бұрын

    Thank you very much

  • @catherinebuchafwe4894
    @catherinebuchafwe4894 Жыл бұрын

    thank youu🎉

  • @stanleystlot3369
    @stanleystlot33692 жыл бұрын

    THANK YOU SO MUCH FOR YOUR HELP 🙏👍👍👍👍👏👏👏

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    You are always welcome!

  • @basilisayessicaokomo2248
    @basilisayessicaokomo2248 Жыл бұрын

    HELLO, I HAVE MANAGE TO VIEW PROPERLY WHAT I ASK FOR YSTERDAY THANK YOU SO MUCH FOR YOUR TUTORIAL I REALLY LEARN MUCH FROM YOU WELL DONE!!!!!

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Thanks for visiting our channel, please watch other videos they are more informative and please like subscribe and share to your family and friends Thank you 🙏

  • @beulah6713
    @beulah67132 жыл бұрын

    Thanks for this I did mine and it came out well

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thanks for visiting our channel, please watch other videos they all are very informative too. Please like videos subscribe channel and share to your family and friends. Thank You 🙏

  • @haniarashid9778
    @haniarashid97783 жыл бұрын

    Nice 👌👌

  • @PrimalEduWorld

    @PrimalEduWorld

    3 жыл бұрын

    Thanks 😊

  • @nikhiljadhav8090
    @nikhiljadhav8090 Жыл бұрын

    Very helpful

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Nikhil Jadhav, Thanks for visiting our channel please watch our other videos they are more informative too and please like subscribe and share to your family and friends. Thank you 🙏

  • @basilisayessicaokomo2248
    @basilisayessicaokomo2248 Жыл бұрын

    hello, you are teaching well may i please have the macro builder actions more clear i mean can you increase the zoom i can see properly in that part

  • @faridaparkar7065
    @faridaparkar70653 жыл бұрын

    👍

  • @damodaramishra4728
    @damodaramishra47282 жыл бұрын

    Very nicely explained

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thank you so much :)

  • @shaistaharoonmuhammadharoo201
    @shaistaharoonmuhammadharoo2012 жыл бұрын

    Helpful tips by you

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Glad to hear that

  • @dionukshini
    @dionukshini Жыл бұрын

    So helpfull, Thanks :)

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Dear Dlon, Thanks for visiting our channel please watch our other videos they are more informative too, please like subscribe and share to your family and friends. Thank you 🙏

  • @asteriaiitula4107
    @asteriaiitula410710 ай бұрын

    Now I have a clue to my project

  • @PrimalEduWorld

    @PrimalEduWorld

    10 ай бұрын

    Dear Thanks for visiting our channel please watch our other videos they are more informative and subscribe like and share to your family and friends Thank you 🙏

  • @araaratoaratow2116
    @araaratoaratow21162 жыл бұрын

    Wow

  • @user-uj5gs4ei2k
    @user-uj5gs4ei2k2 жыл бұрын

    GREAT TEACHER^^

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thank you so much 💕💕

  • @catherinebuchafwe4894
    @catherinebuchafwe4894 Жыл бұрын

    this was really helpful

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Dear Catherine, Thanks for visiting our channel, please watch other videos they are also helpful and informative. So please watch share to your family and friends and do not forget to subscribe to our channel. Thank you 🙏

  • @MrCrazyApp
    @MrCrazyApp Жыл бұрын

    Please create the continuation to this video. Once those macros are created? How do we limit the data the the users will view? And you may want to create other videos for example how to create an application where users don’t see anything about access comanda or other information. Basically how to create a shareable app. You can create also a video about how to create and app and distribute it (just for information purposes or to update a central database. And how users knows that there’s a change in the app and they need to make an update. This video is very well explain so I think that you have tue ability to teach very well.

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Thanks for visiting our channel and glad to know that you like my work, regarding your questions if you will go through my comments section you will get answers of most of your questions. For many subscribers I already answered how to hide Access commands section etc. Please watch my other videos specifically QR CODE ATTENDANCE, I hope you will like most. Please like subscribe and share to your family and friends. Thank you 🙏

  • @MrCrazyApp

    @MrCrazyApp

    Жыл бұрын

    @@PrimalEduWorld Thank you for your reply. But seeing the other posted questions, my humble suggestion is that you create a new video talking into consideration all aspects. You can divide it in parts. We can find other videos on KZread but the way you explain is unique. So for the benefit of all of us, please think about it. Thanks!

  • @MrCrazyApp

    @MrCrazyApp

    Жыл бұрын

    Also, I’m sure that we all can be share those videos in the different Specialize Access Forums that we are subscribed. That way, your work will be recognize by a lot of new people.

  • @MrCrazyApp

    @MrCrazyApp

    Жыл бұрын

    One of the issues is the roll out of an app. There’s only a few ways to do it and some of them charge per user. I’m not sure about the share point option. Maybe that’s an alternative. Of course, we need to split the database. But using Dropbox and other spaces doesn’t work because the database could be corrupted. But if you accept to create a series of videos showing people how to create an application from start to end, definitely will need to evaluate what is the best option, depending if the creator wants to offer to the users just real time information or if the user wants to interact with the data. Those are two different approaches.

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Thanks for your valuable suggestions, I will definitely work on it.

  • @jayetaroy3209
    @jayetaroy32092 жыл бұрын

    👍🏾👍🏾👍🏾

  • @3xtraptical587
    @3xtraptical58710 ай бұрын

    LIFE SAVERSSS

  • @PrimalEduWorld

    @PrimalEduWorld

    10 ай бұрын

    Thanks for visiting our channel please watch our other videos they are more informative too. Also please like share and subscribe to my channel Thank you 🙏🏼

  • @shridhardas2583
    @shridhardas25832 жыл бұрын

    Op

  • @rasheedmuhammad3599
    @rasheedmuhammad3599 Жыл бұрын

    nice to hear you. Allah bless you.Have you school management comprehensive system uploaded? Pl reply

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Thank You for visiting our channel and your encouraging feedback. Please watch our other videos they are more informative and please like, share and subscribe to our channel.

  • @cindyrussell5963
    @cindyrussell5963 Жыл бұрын

    Hello, thank you so much for this simple video. I'm creating a simple database. How do you have the log in screen to appear first then the switch/dashboard in Access? Cam you do a video on that please?

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Sure, Thanks for visiting our channel, please watch other videos they are more informative and like, share and subscribe for more updates. Thank you 🙏

  • @ebertgutierrezramos
    @ebertgutierrezramos Жыл бұрын

    I have an message when running the code “The expression you entered has a function name that Microsoft Access can’t find.” I have watched your video multiple times.

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Dear Ebert, Thanks for visiting our KZread channel, please watch other videos they are very informative, please share and subscribe our channel. With regards to error if you watch video 4 to 5 times carefully and follow the steps then you should not got any error. Also if you installed MS Office is not genuine they you might get errors. Thank you 🙏

  • @rufi4you
    @rufi4you Жыл бұрын

    sorry i don't understand why you use dcount. this way you only check if the textfields are not zero. neither the username nor the password are compared. or where am i making the mistake?

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Brother you are also correct and not doing mistakes, there are many ways we can do programming. All the very best and please do not forget to watch our other videos like and subscribe to my channel. Thank you 🙏

  • @onlinedeka6558
    @onlinedeka65582 жыл бұрын

    MKD Mixture

  • @kenaknrodbrendan1126
    @kenaknrodbrendan11265 ай бұрын

    which option can you use incase the password does not match

  • @mosjany
    @mosjany Жыл бұрын

    How do i pass the current loggon use to a form using the above macro

  • @PrimalEduWorld

    @PrimalEduWorld

    11 ай бұрын

    Brother Mosjany, Thanks for visiting our channel, regarding your query firstly you must have IT professional and with the help of Visual Basis latest version you can pass the current logon! Hopefully you have got your answers. Please watch our other videos which are more informative, please like subscribe to our channel and share to your family and friends. Thank you 🙏

  • @oxpertecautomations2858
    @oxpertecautomations28588 ай бұрын

    I need this software

  • @NguyenTam-zl2tk
    @NguyenTam-zl2tk2 жыл бұрын

    Hi, please guide me how to prevent users from viewing content tables in database. Thank you!

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    If you don't want users to see a table in an Access database, you can mark the table as a hidden object. To do this, right-click on the table that you wish to hide and select “Hide in this Group" from the popup menu. Now when you view your database, the Orders table should be hidden. Please like share and subscribe our channel and watch other videos they are informative Thank You 🙏 Or Open the web app in Access and select the table you want to lock from the Table Selector in the left pane. Click Settings/Actions > Lock. The Lock icon appears next to the name of the table.

  • @NguyenTam-zl2tk

    @NguyenTam-zl2tk

    2 жыл бұрын

    @@PrimalEduWorld Thank you for your early reply, I have subscribed to your channel. But can you tell me more is there any way to prevent the user from doing the operation of not hiding the tables because they can do it if we make the tables hidden your way. Thank you.

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Dear Nguyen, what you are looking is high level programming in SQL sever. My suggestion would be to provide them with a GUI interface; either a program or a web page. This way the user has no direct access to any of the tables since their only access is the page they are looking at. Hope this way you can restrict the user. Thank You and all the very best 🙏

  • @ozcatering8556
    @ozcatering85562 жыл бұрын

    When I login with one user, my all users automatically changed to same user in database and when I close and open the database the username and password is autofill.

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Hi, Thanks for visiting our channel, regarding your 1st question you might doing mistakes in table, in login form department and level of users are very important so you please watch our video 4 to 5 times carefully and hopefully you will get your answers. Regarding your 2nd question, please do the following, Open a form in Design view mode. Select the combobox. Right-click on the combo-box and select Properties to open the property sheet for the combo box. In the AutoExpand property box, click No. Thank You 🙏

  • @ozcatering8556

    @ozcatering8556

    2 жыл бұрын

    @@PrimalEduWorld Thank you!

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    You are most welcome, please watch our other videos they are also more informative, if possible please subscribe, like and share to friends. Thank You 🙏

  • @couldbe2187
    @couldbe21872 жыл бұрын

    someone help plz !!!!! microsoft access cannot parse the expression (DCount("UserName","LOGIN","UserName=[Text1] and Password=[Texte]"))>0

  • @couldbe2187

    @couldbe2187

    2 жыл бұрын

    (DCount("UserName","LOGIN","UserName=[Texte1] and Password=[Texte3]"))>0

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thanks for visiting our channel, Brother I have explained every step in detail so please watch the video 2 to 3 times carefully and your problem will solve. 🙏🏻

  • @ryanm.8282
    @ryanm.8282 Жыл бұрын

    This is well informative, thanks a lot. I used it to open a TABLE but I cannot make a log out button since there is no design for table such as a button, what to do with this? BTW what is the macro for other users like Mr. Kumar to log-in?

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    Dear Ryan, Thanks for visiting our channel, please watch other videos like share and subscribe to our channel. If you are working on database then to exit from mysql type quit at the mysql> command-prompt. Regarding your second query please watch video 3 to 4 times carefully and hopefully you will find your answers. Thank you 🙏

  • @ryanm.8282

    @ryanm.8282

    Жыл бұрын

    @@PrimalEduWorld thanks though im still working on it, one last question if u may, i dont see its function being a password protected file since when i close the Access then reopen it again i can still open all access files on the left side, take note that my login form is still working but it does not give its real purpose if i can still open all of it from the left side

  • @PrimalEduWorld

    @PrimalEduWorld

    Жыл бұрын

    A great way to prevent user access to data is to split your database, thus putting your data tables in one database file (the back-end), and your user interface in another database file (the front-end). Then password protect your back-end database, and hide the Navigation pane in your front-end.

  • @ryanm.8282

    @ryanm.8282

    Жыл бұрын

    @@PrimalEduWorld This is what i need to know though I'm not sure how to. anyway thanks for your help! I'am still learning from scratch so its really hard for me😅

  • @ryanm.8282

    @ryanm.8282

    Жыл бұрын

    @@PrimalEduWorld i get it now, i should not create the syntax DLookup..=1 inorder for other users to be able to login, thanks Prima!

  • @prinxtushtech......1204
    @prinxtushtech......1204 Жыл бұрын

    post the macro command on the comments

  • @PrimalEduWorld

    @PrimalEduWorld

    11 ай бұрын

    Dear Prinx, Please watch our the video 4 to 5 times and you will get macro commands. Also please watch our other videos they are more informative, please like subscribe and share to your family and friends. Thank you 🙏

  • @user-fm4su2xv8c
    @user-fm4su2xv8c3 ай бұрын

    I did not understand the first coding

  • @PrimalEduWorld

    @PrimalEduWorld

    3 ай бұрын

    Thanks for visiting our channel, Watch the video again and again and you will understand the coding Please like and subscribe to our channel Thank you 🙏🏼

  • @kamilatea7533
    @kamilatea75332 жыл бұрын

    I am getting a syntax error

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thanks for visiting our channel, for syntax error you are making mistakes in formula so please watch our video 4 to 5 times carefully and your problem will solve. Also please watch our other videos they are very informative and subscribe, like our videos and possible then share with your friends. Thank You 🙏🏻

  • @sardariftikhar1704
    @sardariftikhar17042 жыл бұрын

    hindi. or urdu language

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thanks for visiting our channel, In Sha Allah we will try to upload in Hindi or Urdu language in future. Please our other videos which are in Hindi and subscribe and like our videos. Thank You 🙏

  • @Th4n0s369
    @Th4n0s3692 жыл бұрын

    THE CODE DID NOT WORK!

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Thanks for visiting our channel, for code error you are making mistakes in formula so please watch our video 4 to 5 times carefully and your problem will solve. Also please watch our other videos they are very informative and subscribe, like our videos and possible then share with your friends. Thank You 🙏🏻

  • @kvai6422
    @kvai64222 жыл бұрын

    Great video,Thank you 👍

  • @nadiaumberlodhi1514
    @nadiaumberlodhi15142 жыл бұрын

    Good

  • @worldislamictv2436
    @worldislamictv24363 жыл бұрын

    Great ur trips!

  • @PrimalEduWorld

    @PrimalEduWorld

    3 жыл бұрын

    Thanks 🙏

  • @goldenxity4321
    @goldenxity43212 жыл бұрын

    Good

  • @PrimalEduWorld

    @PrimalEduWorld

    2 жыл бұрын

    Please subscribe our channel for more informative educational videos in future.