Advanced Login and Registration System using Visual Basic 6.0 and MS Access-Step by Step Tutorial

[@imanamsyar7879]

Thanks a lot to Mr. SK with your best lecturer. I can follow step-by-step your instruction.

[@SandeepKaundalSir]

+Iman Amsyar78 Thanks for your words...See my complete tutorial Series here kzbin.info/aero/PLcZgBCY7duW9H_-jOl5vdRptAHwZYShwr Hope you like it...

[@harshagajalellu6059]

Thanks for video Helped me in my project

[@hollowcode6722]

super bro itz very awesome and so simple to do a login and register form using VB but the video goeson very fast so I can't able to concentrate on your coding part so next time I request u to upload video with an minimum frame speed. apart from that itz so superb... :)

[@ishaqusman5951]

Sir I am really Appreciate with your latest post on VB,

[@treb09hfn]

Very informative. Thanks sir Sandeep.

[@FZHDGaming]

Thanks a lot Mr.

[@SandeepKaundalSir]

You are most welcome

[@biswajitsamal3147]

thank u bro for a complete tutorial........

[@mohamedaslam1154]

THANKS MAN... AWESOME TUT.. HELPED ME A LOT

[@SandeepKaundalSir]

+Mohamed Aslam you are welcome.Watch my other tutorial as well. Hope you like them :-)

[@DeepakSharma-yr5co]

Thanks Sir. This is very helpful in my project :)

[@indaygonie]

thank you very much!!!it helps me a lot for my system project!!!

[@SandeepKaundalSir]

I am glad to hear you ..it helped you in ur project.. Please check my other videos too.. Don't forget to Subscribe Support and LIKE.

[@ytkarina2867]

thank you for this tutorial.... this is very helpful.

[@SandeepKaundalSir]

You are welcome .. Please check my latest videos as well... Hope you find them useful... Good Luck

[@luckyeddy350]

This has been highly helpful.

[@SandeepKaundalSir]

Thank you Eddy....Please check my latest videos and give your valuable feedback....

[@awaisahmed4966]

Could you tell which version is this of sccess ? office 2002 or 2007 ?

[@SandeepKaundalSir]

Use 2003 or 2007

[@greenleaf8661]

thanks man .. i followed the steps and i finished it, i need help i'm working on my program its a memo/planner with login and register system. i want to know how to connect those memo/plan that was encoded by a specific user/account that no one can access the file but only the user who made it? :) please reply thank you.

[@Sumedhpatwardhan]

thank you so much , this is helped me a lot in my project

[@SandeepKaundalSir]

Keep learning..... Please Share Support and Subscribe to My channel..

[@shefaliyadav]

I'm using VB 2010 because the VB 6.0 version is just unavailable and hence am not able to find some things like right-click->components is not possible.....please help me. I am creating a library management system and for the login i need to provide each teacher with their own login thus i want to know how to select things like microsoft common control and also because of this version of vb i am not able to connect to the access database.

[@souravnandy2296]

plz add more and more and more intresting videos for vb 6.o

[@mikeherrera8170]

Hi thank you for the video. Im wanting to know how can i ge the box to display the user information when they login. Im trying to make a time card. The window that pops up after login will be the user information pertaining to the one that logged in.

[@angelabi9044]

when i tried to put the code for the login command, it keep on sying debug for "loginado.refresh" i almost back to the start but still dont work

[@angelabi9044]

Data type mismatch in criteria in expression, refresh method of object 'IAdodc' failed

[@SandeepKaundalSir]

+Angela Guico In Simple Steps, Do the following checking in your program. In Record Source property of ADO Data Control, you must select Adcmdtext as Command Type and Command Text as Select * from tablename. And Under the Command Button of VB Form, SQL Statement must have the valid syntex. This will fix the error “loginado.refresh method failed” “Method 'Refresh' of object 'IAdodc'failed”. Such errors are encountered only when Command Type of ADO Data Control is set to adCmdTable. Also,Verify the Database’s Table Name and Corresponding Fields with their data Type. If these field’s Type of DB does not match with criteria expression written in the Query (SQL Statement Written under Login Command Button, Check specifically WHERE clause followed by Condition) then, you will get the error “Data Type Mismatch”. You may also refer to the link for code selfcomputerlearning.blogspot.com/2015/11/advance-login-system-using-visual-basic.html Hope you will be able to fix the issues. Best of luck.

[@angelabi9044]

Already fixed it. Thanks a lot. I just changed the datatype of ID NUMBER or Rollino in your video as Text instead of Number, i guess text can accept numeric and text at the same time. I researched and I found out that '" in the code is just for string, i tried #txtuser# but still it doesnt work. Thanks :)

[@SandeepKaundalSir]

+Angela Guico My Pleasure. Keep on learning.

[@bhozxwhunjhom]

thank you! :) i finally finish my system defense :)

[@SandeepKaundalSir]

You are welcome :-)

[@5211486]

very helpful video to me.

[@SandeepKaundalSir]

+Faisal Aslam Thanks..Please check latest video tutorials on Channel and give your valuable feedback...

[@lushann5018]

Nice tutorial sir. Question, what if I already registered and my information is already in the database but REGISTERED again. How to prevent the double registration of information in the database?

[@strikerash1227]

Sir if I enter again same data by mistake in database also same primary key then I want an error in msgbox how I can do it sir.

[@yuvrajbhandari9456]

Hey! +Sandeep Kaundal i'm using MS ACCESS 2010 and i am not able to create the database so can u help me out...

[@SandeepKaundalSir]

You can create ur Database in access 2010,.and change it into 2003 format using Save as option.

[@juzer1142]

sir the name of the label must be lblstat or we can keep anything??

[@dsrraujodhpur4787]

sir 1- how to link one access database table to another database form. 2- how to password protect table (only table not whole database) in ms access database

[@juzer1142]

sir when i write this code registerado.Recordset.Fields("Rollno") = txtroll.Text and registerado.Recordset.Fields("Phone no") = txtphone.Text after writnig this code when i run the software and i try to register a new member this error comes Run time error "3265" Item cannot be found in the collection corresponding to the requested name or ordinal sir please hellp wht to do with that error

[@deltaruc]

Thanks this help me alot. :))

[@SandeepKaundalSir]

+Del Taruc it's my pleasure....Share it and watch my other tutorials on youtube.

[@gopi8688]

its very use full for me. i have some question? How to communicate delta plc with vb

[@SandeepKaundalSir]

Just leave the comment here.. I am here to help you. Don't worry ...

[@vorapobautomation9760]

Can create this program into .OCX or ActiveX file ?

[@yamunanandpandey3100]

when i,m register information then save false false data in acess database why?

[@sayantansaha2703]

Mr. SK sir,for this project you use ADODC for conecting the database, bt if i want to implement the same project using ADODB, what's the code for it??? Also i want to rqst you for making some tutorials using ADODB in vb6.

[@vijayshelar1857]

Sir I have numeric field in access and in form I have textbox, I want to match partly for fully textbox with the field, how should i do it?

[@mikevincents.bautista3700]

Can I ask what version of your 2 Visual Basic?

[@SandeepKaundalSir]

Vb6

[@nilharris7909]

Hi SK, Thanks for such Wonderful work, I dont have VB on PC, Can i create same form using only access & vba comes alongwith it.

[@SandeepKaundalSir]

You can also create this login form same as it is ,using VBA and MS Access. Just send me a message.. I am here to help you...

[@mikeherrera8170]

Also if you can answer how can i get the date and time stamp to save in access with that users information and what option button is pressed . Thanks.

[@sahilverma1431]

i am getting error in last login form coding loginado.refresh i have completed upto login form and there os problem in coding and i am not able to connect login btn with app form

[@juzer1142]

and sir which language is are you using for coding section??

[@chiragharwani4175]

Thanx ur video was really helpful but can u tell me the coding for forget password button in login form my sir has asked me to add forget password code if someone forgets his/her password then how to retrieve it back....plz help I have to submit my project next week

[@patrickc6229]

runtime error appears. "App.frm could not be loaded" please help

[@theprshntaggrwl]

is there any possibility to create sms sending function in vb6.if yes then how...

[@davidmu9893]

How did you get the tiny X button on the Welcome to SMS form???

[@SandeepKaundalSir]

+Davidu Mu I think ,you are asking for the tiny Close button at the right corner of Welcome form. to do this,do the following Click on any form (welcome form) in Project Explorer. goto the properties of that form: Set the following properties Borderstyle:4-toolwindows ControlBox :True (if this property is false,then No Close/Maximize/Minimize Button will appear on the right corner of the form) MaxButton:False MinButton :False Save your project and Run..!! Its done... if you still have any issue,let me know..

[@tan-aye]

can't find adodc control in my vb '15

[@layaung8036]

thank

[@abdullahiahmed7077]

You are so faster brother

[@DaleOfficial]

im getting error on the adodc1.refresh on the login button how to fixxx?

[@SandeepKaundalSir]

+Dale Official. Such errors are encountered only when Command Type of ADO Data Control is set to adCmdTable. In Record Source property of ADO Data Control, you must select Adcmdtext as Command Type and Command Text as Select * from tablename. And Under the Command Button of VB Form, SQL Statement must have the valid syntax. This will fix the error “loginado.refresh method failed” “Method 'Refresh' of object 'IAdodc'failed”.

[@abhishektidke1310]

In login form coding it is showing error "method or data member not found " at line textuser.text

[@abhishektidke1310]

pls tell as early as possible

[@rajnidhaliwal2877]

Sir next multiple user login ki koi video bano

[@erophilia7403]

Thanks a lot :D

[@SandeepKaundalSir]

+Joshua Rizo My Pleasure :-)

[@pattolentino1013]

loginado.refresh doesnt work. why?

[@SandeepKaundalSir]

+patricia tolentino please mention the error name .

[@christiansagadal4196]

Sir, Can i connect this system to a barcode or scanner? Answer me please :D

[@salmansaddiqui1525]

thanks a lot

[@jesryloccena9680]

sir pano po lumabas ang welcome sms

[@factsvideos21]

Sir . can you make a video about a ordering app like a pizza app with combo box in the pizza flavor and option box and it has a command button for the receipt . can you show the codes about " how to make a receipt?" thank you very much

[@bhozxwhunjhom]

i think i can help you with that!

[@bhozxwhunjhom]

pm me on fb. facebook.com/biik30 and i will send you the code and the pizza app design. im using vb6.0 :)

[@pengzhengang6527]

thx a lot

[@papeejtv909]

what if i have admin user and employee user that can log on it

[@SandeepKaundalSir]

+Patrick Galura We can make the provision in our VB form for separate login as Admin User or Employee user and assign Access Privileges as per User. First, to Admin ,Provision to use whole database under admin login. (ADD,Remove,Access Privileges to users,Modifying Login credentials etc) Secondly,For employee user,Only a specific application of database should be used by them.Hope u find ur answer.. :-)

[@papeejtv909]

thanks 😊

[@abethpaet199]

+Sandeep Kaundal Sir. can you make a tutorial of this one? :)

[@SandeepKaundalSir]

+Abeth Paet Sure...!! Probably next week...

[@علیعلی-ظ8ط5ن]

Hey Sandeep.I need a help about scrollbar in vb6

[@SandeepKaundalSir]

Please tell me about ur issue?? I will try to solve this.

[@علیعلی-ظ8ط5ن]

Scroll bar is not working.

[@علیعلی-ظ8ط5ن]

when i set code in it it just work only on one lable.and other doesnt move in one form

[@jasonrose5583]

how to disable submit button with out filling up the registration form? Thank you in Advance sir 😉

[@SandeepKaundalSir]

+Jason Rose Sorry,Not understand much about ur question. But i suggest you to do the following steps to disable the command Button. Simple Code to disable or enable command button by setting Enabled property of Command Button to True or False. command1.Enabled=False (Disable Button) command1.Enabled=True (Enable Button) Situation where you disable or enable the command button. Suppose you have created a Registration form,in which you take Two Textbox controls and Two command buttons (Register and Cancel). 1.While Loading the form ,you want to disable the Register command button. 2.When you click in the textbox and Type anything in the textbox then Register Button should be enabled in order to store the information. Solution: Ans-1 :for Disabling the Command Button While Loading:- (No Task will be Performed) First Double click on form .Form_Load Event automatically appear in the code window. Just type the code under form_load event. Private Sub Form_Load() Command1.Enabled=False. End it means when your Registration Form will be loaded ,your Register Button will be Disabled. Ans-2 :For Enabling the command Button When you enter data into the textbox:- (Will execute the task.) Open code window and Select Text1 from Object List (First Dropdown list) and Select Click from Procedure List (Second Dropdown List). here type the code.Private Sub Text1_Click() command1.Enabled =True. End This will enable the command button to perform task. There are so many other cases where you can enable and disable the command button in order to build application effectively. if you have issues related to visual basic,Let me know.I will assist you.. Best of Luck.

[@jayrawat1761]

sir how we connect the application with the database server.

[@sonuvlogs1832]

Hello sir login refresh me error show ho raha hai sir syntax error bata raha hai help us

[@SandeepKaundalSir]

Check the code once.

[@sonuvlogs1832]

Sir check kiya but fir bhi

[@markanthonymonteros9037]

Good day can I ask a favor?

[@ilkhambayuseptyawan315]

Can aim personal private with your Mr..?

[@s-linkcomputer5594]

SIR PLEASE ONE OF THE ANOTHER TUTORIAL FOR COMMON DIALOGBOX

[@pattolentino1013]

whats the code for reset button

[@SandeepKaundalSir]

+patricia tolentino Reset Button is the only way to reset all the fields of Visual Basic Form to default value. Double Click on Reset Command Button and implement this code to reset the fields. textbox1.text=" " (If you are using Textbox control on VB form) label1.caption=" " (if you are Using Label Control) if you are still facing any issues ,let me know.

[@s-linkcomputer5594]

thanks super

[@SandeepKaundalSir]

+john sonu :-)

[@beatricenyaki4558]

Hello Sir! how can i get into contact with you personally?

[@SandeepKaundalSir]

just drop an email at [e-mail]

[@serialrappersofficaltv3356]

Sir I Help Me I Create a Professional Editing Software For Pc Just I Help Me

[@kunjlatakumari3900]

sir apke speek nahi aatte h

[@teodorof.teodoro-i5150]

RESET?

[@cutepuffpaws4420]

data1.recordset.addnew in load is not working

[@SandeepKaundalSir]

Kindly check the code and name property of control added to vb form.

[@imanamsyar7879]

Thanks a lot to Mr. SK with your best lecturer. I can follow step-by-step your instruction.

[@edzelbautista4054]

Method or data member not found? Whyyyy?

[@dsrraujodhpur4787]

sir 1- how to link one access database table to another database form. 2- how to password protect table (only table not whole database) in ms access database