No video

CREATE LOGIN FORM IN ACCESS USING MACRO EVENT!!

  Рет қаралды 52,630

Primal EduWorld

Primal EduWorld

Күн бұрын

Пікірлер: 121
@PrimalEduWorld
@PrimalEduWorld 3 жыл бұрын
Follow us on Instagram: instagram.com/primal_eduworld/ Follow us on Facebook: facebook.com/primaleduworld/
@sammenon7261
@sammenon7261 2 жыл бұрын
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
@aliakhan3278 2 жыл бұрын
Thanks for sharing this video, today I learnt MS ACCESS almost everything.
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
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 KZfaq 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.
@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 🙏
@maysak3595
@maysak3595 2 жыл бұрын
This was very detailed info...thanx for sharing
@dkquicksupport
@dkquicksupport 2 жыл бұрын
Waoo that's really very nice and informative
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
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
@taslimtisekar6140
@taslimtisekar6140 2 жыл бұрын
Very nice video..thank you for the upload 👍
@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 🙏
@jacobmathew4
@jacobmathew4 6 ай бұрын
God presentation
@PrimalEduWorld
@PrimalEduWorld 6 ай бұрын
Thank you
@haniarashid9778
@haniarashid9778 3 жыл бұрын
Nice 👌👌
@PrimalEduWorld
@PrimalEduWorld 3 жыл бұрын
Thanks 😊
@smttomar
@smttomar 3 жыл бұрын
Nice informative video
@worldislamictv2436
@worldislamictv2436 3 жыл бұрын
Great ur trips!
@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 🙏
@AliAbbas-xq9dn
@AliAbbas-xq9dn 2 жыл бұрын
Keep it up
@rheac4306
@rheac4306 2 жыл бұрын
Very informative video I have seen today, very well explained step by step.
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
Thanks 🙏
@amanu78
@amanu78 Жыл бұрын
Thank you very much
@faizkhan4840
@faizkhan4840 2 жыл бұрын
Superb.. 👍
@tarakapadia7515
@tarakapadia7515 2 жыл бұрын
Nice video 👍
@dishakiduniya1803
@dishakiduniya1803 2 жыл бұрын
Nice information keep it up 👍
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
We surely will!! And thanks ❤
@superoshineproducts507
@superoshineproducts507 2 жыл бұрын
Very nice
@anjanamishra5518
@anjanamishra5518 2 жыл бұрын
Thank for sharing this information ☺️
@kenaknrodbrendan1126
@kenaknrodbrendan1126 6 ай бұрын
which option can you use incase the password does not match
@AmitKumar-ym8kl
@AmitKumar-ym8kl 2 жыл бұрын
Lovely
@kantabamola5826
@kantabamola5826 2 жыл бұрын
Well explained
@rasheedmuhammad3599
@rasheedmuhammad3599 2 жыл бұрын
nice to hear you. Allah bless you.Have you school management comprehensive system uploaded? Pl reply
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
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.
@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 KZfaq 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 🙏
@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
@asteriaiitula4107 11 ай бұрын
Now I have a clue to my project
@PrimalEduWorld
@PrimalEduWorld 11 ай бұрын
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 🙏
@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 🙏
@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 🙏
@damodaramishra4728
@damodaramishra4728 2 жыл бұрын
Very nicely explained
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
Thank you so much :)
@cindyrussell5963
@cindyrussell5963 Жыл бұрын
Thank you and will be looking forward to it
@PrimalEduWorld
@PrimalEduWorld Жыл бұрын
Great!
@mosjany
@mosjany Жыл бұрын
How do i pass the current loggon use to a form using the above macro
@PrimalEduWorld
@PrimalEduWorld Жыл бұрын
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 🙏
@shaistaharoonmuhammadharoo201
@shaistaharoonmuhammadharoo201 3 жыл бұрын
Helpful tips by you
@PrimalEduWorld
@PrimalEduWorld 3 жыл бұрын
Glad to hear that
@travelfar1845
@travelfar1845 2 жыл бұрын
Beautifully explained 👍
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
Thank you 🙂
@stanleystlot3369
@stanleystlot3369 2 жыл бұрын
THANK YOU SO MUCH FOR YOUR HELP 🙏👍👍👍👍👏👏👏
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
You are always welcome!
@user-sh6tp4dj7l
@user-sh6tp4dj7l 2 жыл бұрын
Thanks for sharing this information 💁‍♀️ ~~~
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
Thank You dear 🙏
@kvai6422
@kvai6422 3 жыл бұрын
Great video,Thank you 👍
@faridaparkar7065
@faridaparkar7065 3 жыл бұрын
👍
@nadiaumberlodhi1514
@nadiaumberlodhi1514 3 жыл бұрын
Good
@user-uj5gs4ei2k
@user-uj5gs4ei2k 2 жыл бұрын
GREAT TEACHER^^
@PrimalEduWorld
@PrimalEduWorld 2 жыл бұрын
Thank you so much 💕💕
@beulah6713
@beulah6713 2 жыл бұрын
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 🙏
@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 🙏
@trishamajumder7803
@trishamajumder7803 3 жыл бұрын
Great
@danielmladin8486
@danielmladin8486 3 жыл бұрын
Thank you, good info
@3xtraptical587
@3xtraptical587 11 ай бұрын
LIFE SAVERSSS
@PrimalEduWorld
@PrimalEduWorld 11 ай бұрын
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 🙏🏼
@zakwanjam
@zakwanjam 2 жыл бұрын
Wonderfulllllllllllllllll!!!!!!!!!!!!!!!!!
@oxpertecautomations2858
@oxpertecautomations2858 9 ай бұрын
I need this software
@NguyenTam-zl2tk
@NguyenTam-zl2tk 2 жыл бұрын
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
@ozcatering8556 2 жыл бұрын
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 🙏
@catherinebuchafwe4894
@catherinebuchafwe4894 Жыл бұрын
thank youu🎉
@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!
@couldbe2187
@couldbe2187 2 жыл бұрын
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. 🙏🏻
@user-fm4su2xv8c
@user-fm4su2xv8c 5 ай бұрын
I did not understand the first coding
@PrimalEduWorld
@PrimalEduWorld 5 ай бұрын
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 🙏🏼
@Th4n0s369
@Th4n0s369 2 жыл бұрын
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 🙏🏻
@araaratoaratow2116
@araaratoaratow2116 3 жыл бұрын
Wow
@kamilatea7533
@kamilatea7533 2 жыл бұрын
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 🙏🏻
@onlinedeka6558
@onlinedeka6558 2 жыл бұрын
MKD Mixture
@jayetaroy3209
@jayetaroy3209 3 жыл бұрын
👍🏾👍🏾👍🏾
@prinxtushtech......1204
@prinxtushtech......1204 Жыл бұрын
post the macro command on the comments
@PrimalEduWorld
@PrimalEduWorld Жыл бұрын
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 🙏
@shridhardas2583
@shridhardas2583 3 жыл бұрын
Op
@sardariftikhar1704
@sardariftikhar1704 2 жыл бұрын
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 🙏
@mamagaming1575
@mamagaming1575 3 жыл бұрын
Great ur trips!
@catalinboronschi950
@catalinboronschi950 3 жыл бұрын
Great video,Thank you 👍
@urdughazal1748
@urdughazal1748 3 жыл бұрын
Good
@goldenxity4321
@goldenxity4321 3 жыл бұрын
Good
@PrimalEduWorld
@PrimalEduWorld 3 жыл бұрын
Please subscribe our channel for more informative educational videos in future.
How to Add Simple User-Level Security to Microsoft Access Databases
26:44
Computer Learning Zone
Рет қаралды 36 М.
56. Creating A Classic Login Form (Programming In Microsoft Access 2013) 🎓
28:00
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 13 МЛН
Yum 😋 cotton candy 🍭
00:18
Nadir Show
Рет қаралды 7 МЛН
CREATE LOGIN FORM IN ACCESS USING MACRO EVENT [ NEW UPDATE ]
17:38
PUTRA RITOYAN
Рет қаралды 15 М.
Set Permission Login Form in Microsoft Access
30:56
Edcelle John Gulfan
Рет қаралды 13 М.
How to create login form in Microsoft Access VBA 2023
15:36
Programming for Everybody
Рет қаралды 26 М.
Login Form in Access without coding only using macros
20:32
Super Learning
Рет қаралды 46 М.
How to create Multi User LOGIN FORM in Ms Access With SECURITY LEVEL | Part-1
17:23
Microsoft Access - Intro to Macros
20:56
Design and Deploy
Рет қаралды 25 М.
microsoft doubles down on recording your screen
10:00
Low Level Learning
Рет қаралды 66 М.
Ultimate Login System in Access Database Project Part-1
14:48
skill header
Рет қаралды 24 М.