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... :)
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.
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.
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?
+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.
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 :)
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.
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.
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
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
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
+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..
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
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
+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.
+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.. :-)
+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”.
+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.
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
Thanks a lot to Mr. SK with your best lecturer. I can follow step-by-step your instruction.
+Iman Amsyar78 Thanks for your words...See my complete tutorial Series here ruclips.net/p/PLcZgBCY7duW9H_-jOl5vdRptAHwZYShwr
Hope you like it...
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... :)
Sir I am really Appreciate with your latest post on VB,
Thanks for video
Helped me in my project
THANKS MAN...
AWESOME TUT..
HELPED ME A LOT
+Mohamed Aslam you are welcome.Watch my other tutorial as well. Hope you like them :-)
Very informative. Thanks sir Sandeep.
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.
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.
thank you! :) i finally finish my system defense :)
You are welcome :-)
This has been highly helpful.
Thank you Eddy....Please check my latest videos and give your valuable feedback....
thank you very much!!!it helps me a lot for my system project!!!
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.
Could you tell which version is this of sccess ? office 2002 or 2007 ?
Use 2003 or 2007
Thanks a lot Mr.
You are most welcome
Thanks Sir. This is very helpful in my project :)
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?
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
Data type mismatch in criteria in expression, refresh method of object 'IAdodc' failed
+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.
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 :)
+Angela Guico My Pleasure. Keep on learning.
thank u bro for a complete tutorial........
thank you for this tutorial.... this is very helpful.
You are welcome ..
Please check my latest videos as well...
Hope you find them useful...
Good Luck
its very use full for me. i have some question?
How to communicate delta plc with vb
Just leave the comment here..
I am here to help you.
Don't worry ...
thank you so much , this is helped me a lot in my project
Keep learning.....
Please Share Support and Subscribe to My channel..
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.
Thanks this help me alot. :))
+Del Taruc it's my pleasure....Share it and watch my other tutorials on youtube.
plz add more and more and more intresting videos for vb 6.o
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.
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
sir the name of the label must be lblstat or we can keep anything??
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.
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...
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.
Hey!
+Sandeep Kaundal i'm using MS ACCESS 2010 and i am not able to create the database so can u help me out...
You can create ur Database in access 2010,.and change it into 2003 format using Save as option.
Can I ask what version of your 2 Visual Basic?
Vb6
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.
very helpful video to me.
+Faisal Aslam Thanks..Please check latest video tutorials on Channel and give your valuable feedback...
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
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
and sir which language is are you using for coding section??
Can create this program into .OCX or ActiveX file ?
Sir next multiple user login ki koi video bano
How did you get the tiny X button on the Welcome to SMS form???
+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..
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
when i,m register information then save false false data in acess database why?
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
i think i can help you with that!
pm me on fb. facebook.com/biik30 and i will send you the code and the pizza app design. im using vb6.0 :)
Thanks a lot :D
+Joshua Rizo My Pleasure :-)
Sir, Can i connect this system to a barcode or scanner? Answer me please :D
Hey Sandeep.I need a help about scrollbar in vb6
Please tell me about ur issue??
I will try to solve this.
Scroll bar is not working.
when i set code in it it just work only on one lable.and other doesnt move in one form
how to disable submit button with out filling up the registration form? Thank you in Advance sir 😉
+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.
Hello sir login refresh me error show ho raha hai sir syntax error bata raha hai help us
Check the code once.
Sir check kiya but fir bhi
is there any possibility to create sms sending function in vb6.if yes then how...
what if i have admin user and employee user that can log on it
+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.. :-)
thanks 😊
+Sandeep Kaundal Sir. can you make a tutorial of this one? :)
+Abeth Paet Sure...!! Probably next week...
In login form coding it is showing error "method or data member not found " at line textuser.text
pls tell as
early as possible
thank
thanks super
+john sonu :-)
thanks a lot
im getting error on the adodc1.refresh on the login button how to fixxx?
+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”.
thx a lot
You are so faster brother
runtime error appears. "App.frm could not be loaded" please help
Good day can I ask a favor?
can't find adodc control in my vb '15
Can aim personal private with your Mr..?
loginado.refresh doesnt work. why?
+patricia tolentino please mention the error name .
sir how we connect the application with the database server.
SIR PLEASE ONE OF THE ANOTHER TUTORIAL FOR COMMON DIALOGBOX
Hello Sir! how can i get into contact with you personally?
just drop an email at sandeep.pgtip@gmail.com
whats the code for reset button
+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.
sir pano po lumabas ang welcome sms
Sir I Help Me I Create a Professional Editing Software For Pc
Just I Help Me
sir apke speek nahi aatte h
RESET?
data1.recordset.addnew in load is not working
Kindly check the code and name property of control added to vb form.
Thanks a lot to Mr. SK with your best lecturer. I can follow step-by-step your instruction.
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
Method or data member not found? Whyyyy?