+Iman Amsyar78 Thanks for your words...See my complete tutorial Series here th-cam.com/play/PLcZgBCY7duW9H_-jOl5vdRptAHwZYShwr.html 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... :)
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.
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
+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 :)
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.
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.
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.
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?
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 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..
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
+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”.
+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.. :-)
+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 th-cam.com/play/PLcZgBCY7duW9H_-jOl5vdRptAHwZYShwr.html
Hope you like it...
Sir I am really Appreciate with your latest post on VB,
Thanks for video
Helped me in my project
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... :)
Very informative. Thanks sir Sandeep.
Thanks Sir. This is very helpful 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 :-)
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.
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.
plz add more and more and more intresting videos for vb 6.o
thank you! :) i finally finish my system defense :)
You are welcome :-)
thank u bro for a complete tutorial........
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
thank you so much , this is helped me a lot in my project
Keep learning.....
Please Share Support and Subscribe to My channel..
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.
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.
This has been highly helpful.
Thank you Eddy....Please check my latest videos and give your valuable feedback....
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
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.
Thanks a lot Mr.
You are most welcome
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.
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?
sir the name of the label must be lblstat or we can keep anything??
Could you tell which version is this of sccess ? office 2002 or 2007 ?
Use 2003 or 2007
Thanks this help me alot. :))
+Del Taruc it's my pleasure....Share it and watch my other tutorials on youtube.
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.
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 ...
very helpful video to me.
+Faisal Aslam Thanks..Please check latest video tutorials on Channel and give your valuable feedback...
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.
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?
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...
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.
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
and sir which language is are you using for coding section??
Sir next multiple user login ki koi video bano
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
Can create this program into .OCX or ActiveX file ?
is there any possibility to create sms sending function in vb6.if yes then how...
Can I ask what version of your 2 Visual Basic?
Vb6
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..
Thanks a lot :D
+Joshua Rizo My Pleasure :-)
can't find adodc control in my vb '15
runtime error appears. "App.frm could not be loaded" please help
thanks a lot
thank
Sir, Can i connect this system to a barcode or scanner? Answer me please :D
thx a lot
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 :)
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
SIR PLEASE ONE OF THE ANOTHER TUTORIAL FOR COMMON DIALOGBOX
You are so faster brother
In login form coding it is showing error "method or data member not found " at line textuser.text
pls tell as
early as possible
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”.
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.
thanks super
+john sonu :-)
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...
sir how we connect the application with the database server.
loginado.refresh doesnt work. why?
+patricia tolentino please mention the error name .
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
Good day can I ask a favor?
Can aim personal private with your Mr..?
Sir I Help Me I Create a Professional Editing Software For Pc
Just I Help Me
sir pano po lumabas ang welcome sms
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.
RESET?
sir apke speek nahi aatte h
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?