Login Form for Excel VBA based Application Connect with MS Access Database Complete Tutorial

#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:

Learn more about ADODB Connection:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[balajimehtre]

Thank you Sharing video..Very nice explained ..keep up the good work..

[chitaranjanbarik]

I' ve been eagerly waiting for this video, your method of teaching is out of the box.

[ashokanselliah]

Fantastic job. Well explained. Thank you so much. Look forward have more videos to share with friends

[we]

Brilliant, keep the good work. Yes, for some people it is fast, but I guess your description fulfills every need.

[without-u]

Thanks, a lot for you good job.

Pleas, Don't stop and keep up in that application with excel and access

[AbhisheakSaraswat]

Please upload more this type of videos using VBA and Ms access

[andychavez]

Thanks a lot for this. One question: will it work in Microsoft Activex Data objects 6.1 library?

[jesuscova]

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?

[romelgaliza]

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.

[MohammadShahid-zzvz]

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.

[tibenkanageorge]

thank u PK: An Excel Expert
how do i link this to my data entry form

[mdilman]

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?

[harshavardhana]

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

[syedikramullah]

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.

[prakashchandra]

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.

[airdropufree]

Hi sir can you help me my personal project?

[roycetagram]

Excuse me which excel version has developer

[pratapjadal]

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..

[alquimcabatuan]

Why there is a debug when i run this code
“Syntax error in FROM clause” ?

[system]

How do I enter anything and turn it off in the "X" and I'm still on the page?