Login Form for Excel VBA based Application Connect with MS Access Database Complete Tutorial
Вставка
- Опубліковано 7 вер 2024
- #VBAUserform #LoginForm
Hello Friends,
In this video you will learn how develop beautiful Login Form in Excel VBA and Connect it with MS Access. We have connected with MS Access using ADODB Connection. To create the design of this Login form we have taken the support of Microsoft Power Point also.
Click here to download the practice files:
www.pk-anexcel...
Learn more about ADODB Connection:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...
Thank you Sharing video..Very nice explained ..keep up the good work..
Thanks for your valuable feedback
I' ve been eagerly waiting for this video, your method of teaching is out of the box.
Hope you enjoyed it!
Fantastic job. Well explained. Thank you so much. Look forward have more videos to share with friends
Thanks for your valuable feedback
Brilliant, keep the good work. Yes, for some people it is fast, but I guess your description fulfills every need.
Thanks for your valuable support and motivational words
Thanks, a lot for you good job.
Pleas, Don't stop and keep up in that application with excel and access
Great thank you sir
Thanks for your valuable feedback
Please upload more this type of videos using VBA and Ms access
It's really very helpful
Thanks for your valuable feedback. Request you to please share this with your friends and colleagues
Definitely sir
amazing, nice tutorial
Thanks for your valuable feedback
Thank you my best friend
Thanks for your valuable comments.
bro, well explained rdbms concept
Thanks for your valuable feedback
Good job bro
Thanks for your valuable feedback
I hope you can continue from here.
Great :)
Hi, nice video. Just one thing: If you write the User_ID Uppercase or Lowercase is the same. You may login succesfully. How can we solve this, so the input in the field User_ID matches the text exactly as in the database?
Thanks a lot for this. One question: will it work in Microsoft Activex Data objects 6.1 library?
Thank you, Pk! Do you have a tutorial on how to convert an excel to .exe with an activation key that works on one computer only? Thanks.
Plz upload more video on vba access
Dear P.K hope you are fine. Very useful.
Can you guide me where we can take Advanced excel training and VBA Macro.
Or someone give to Training on that.
Please help me out.
thank u PK: An Excel Expert
how do i link this to my data entry form
wonderful video PK - Thank you - I have encountered two problems for clear button-
1) when I click the clear button it clears the text box 1, However, there is a single * in textbox 2
2) After clicking the clear button - there is one space after the cursor ni textbox 1 so even if I enter the correct name and password - I get a message invalid username as space is also considered - Please help me fix the issue - Thanks in advance
Nice video sir, i have an issue while trying to attempt this. I am not able to add 2.8 Library as my reference. It will show "Name conflicts with existing module, project, or object library". Can you help me sir?
Sir, when I insert the user form in visual basic the error pop up class root not registered. How to solve this in window 7.
Why there is a debug when i run this code
“Syntax error in FROM clause” ?
Hi pk project is owsome but please tell me if we want to open a password protected access database where I have store user details so how to do this task because we do not want to share it with anyone else and if we will not protect it with pass anyone can see the pass.
Hi sir can you help me my personal project?
Excuse me which excel version has developer
You can use developer tab in Excel 2007 or above version.
Please watch below video, how to enable the developer tab-
ua-cam.com/video/q8AZ2TGbY7M/v-deo.html
@@PKAnExcelExpert alright i got it!! thank you sir!
How do I enter anything and turn it off in the "X" and I'm still on the page?
Its good sir. ... . I have a task. pls pls help me sir. my people are working on different-different locations. everyday they fills a excel form and they sends me. i am planning to create a excel vba form(login form & requirement form) but i want store all database into my Access database. normally we can create vba form and connect with ms access which runs in same computer. but here problem is my people are working in different location...so i am looking online database storage. ms access or any other database which are free. in this scenario i am sharing same copy of excel vba file to all. they will open excel vba file then will log in & fill up requirement form and submit. once they submit their form they can see below their updated form row in below grid. like every location people will do same thing.. only i being admin, with admin login i can see all filled form. and i should have access to make changes. will this work. do we have any option online database. pls can you give me sample. ps sir. pls guide me sir
Sir google form and Microsoft forms are not suitable for me.
i want to use excel vba form as frontend interface and back end will be MS Access or any other.. please help me . do we have any online FREE database systems like access or ms sql..or any other so that we can able to connect our excel vba form to that database..
Mr. Create VBA exel connection for ms outlook
Sure, I will create the complete series of Outlook and Excel connectivity-
You can watch below given videos wherein I have connected Outlook with Excel-
ua-cam.com/video/drttEdY6xDw/v-deo.html
ua-cam.com/video/aD-lo81I5C4/v-deo.html
ua-cam.com/video/A6tggcOV6ts/v-deo.html
I still don't understand what the excel was for...