Sorry for the late reply. I encountered that error because the database file is not on the folder with the vb project. So make sure the database and the project are in the same folder. :)
Could you help me sir ? I have a problem i can't run it , "Format of the initialization string does not conform to the OLE DB specification ." Help me plsss :(
can we change the "username" textbox into combobox? so user just need to choose between the privilege he/she has (Admin/User/Guest) or username already inputted to database , before inputting the password?
sir i have problems with my codes that keeps having the type mismatch error. can you help me? pl.Open "Select * from tblusers where user = '" * User.Text & "'", Login, adOpenStatic, adLockReadOnly this is the line highlighted on me. whats the problem on this?
Dear Clyde, Thank you for the information, I have an error in private sub login() in this line rs.Open "Select * From user Where username = ´" & Text1.Text & "´", cnn, adOpenStatic, adLockOptimistic it says "no value given for one or more required parameters" can you please help me?
it says user defined type not defined its the code on module ADODB.Connection_ this line im newbie at coding and i really need some help for our capstone please help me
lonewolfreaper21 i think you did not select the Microsoft ActiveX Data Objects 2.8 Library. Just go to "Project" > "References" > then look for "Microsoft ActiveX Data Objects 2.8 Library" . i hope it will answer your question.
hi. i have a problem. it always say run-time error 91. object variable or block variable not set. rs.Open "Select * From tblusername Where username ='" & txtuser.Text & "'", cnn, adOpenStatic, adLockReadOnly "how can i debug it please reply. "
@Sara Maher Please see your Module1 and check the PublicSub getconnected() cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Database1.mdb" & "; Persist Security Info=False;" You may have missing letters or symbols. Double check it. Thanks!
I encountered that error because the database file is not on the folder with the vb project. So make sure the database and the project are in the same folder. :)
HI all! If you get an ERROR on this line "Public cnn As ADODB.Connection", i got the SOLUTION. If you have copied the code from the blog, you have copied multiple "_" after the public declaration and before the sub "getconnected", so you have to delete the "_".
my error is "syntax error in from clause" , in (rs.Open "select * from user where username ='" & Text1.Text & "'", cnn, adOpenStatic, adLockReadOnly) line
was an useful video..!! Thank You..!! :-)
Good for beginners.. :)
Thanks!
Welcome..
Hello when i debug it marks me cnn.Open but i have them in the same folder can you please help me
Sorry for the late reply. I encountered that error because the database file is not on the folder with the vb project. So make sure the database and the project are in the same folder. :)
Could you help me sir ? I have a problem i can't run it ,
"Format of the initialization string does not conform to the OLE DB specification ."
Help me plsss :(
What should I do for cnn.open highlighted error?????
Please give me a quick answer
ClydeLee Ramos, just asking, the cnn.open.. it happens to me also.. how do you solve it?
can we change the "username" textbox into combobox?
so user just need to choose between the privilege he/she has (Admin/User/Guest) or username already inputted to database , before inputting the password?
there's a problem sir on cnn.connectionstring run-time '446' why is that sir. can you help me.
what section did you declare the login()
when i debug it marks me the private sub login. i wonder when did you declare the login?
I am getting the same error at cnn.open
how did you solved it??
thanks a lot men! :D
if i have (Admin+user) in the Database .. and when i log in as a user , another form pop up .. so what is the code that can help me? and thnx
sir i have problems with my codes that keeps having the type mismatch error.
can you help me?
pl.Open "Select * from tblusers where user = '" * User.Text & "'", Login, adOpenStatic, adLockReadOnly
this is the line highlighted on me.
whats the problem on this?
getting error on public sub login()
in which section u have declared the login...???
i had this problem :
Error 3706
it's impossible to find the provider
what can i do ?
Dear Clyde, Thank you for the information, I have an error in private sub login() in this line
rs.Open "Select * From user Where username = ´" & Text1.Text & "´", cnn, adOpenStatic, adLockOptimistic
it says "no value given for one or more required parameters" can you please help me?
you are using "user" which is a reserved word. try to change it. please reply if you are still receiving that error message
i have done same but while compiling there is "syntax error from clause"
How I can make with it a multiple login? :c
I tried adding elements in the Data base, and only can entry with one user:c
hi guys how can i connect timer to other label in other form?
it says user defined type not defined
its the code on module
ADODB.Connection_
this line
im newbie at coding and i really need some help for our capstone please help me
error pls help "cnn As ADODB.Connection" error
I got this problem "Compile Error: Use-defined type not defined" help pls???
lonewolfreaper21 i think you did not select the Microsoft ActiveX Data Objects 2.8 Library. Just go to "Project" > "References" > then look for "Microsoft ActiveX Data Objects 2.8 Library" . i hope it will answer your question.
ty man
hi. i have a problem. it always say run-time error 91. object variable or block variable not set. rs.Open "Select * From tblusername Where username ='" & txtuser.Text & "'", cnn, adOpenStatic, adLockReadOnly "how can i debug it please reply. "
sir error.!! method or data member not found help sir..
@Sara Maher
Please see your Module1 and check the PublicSub getconnected()
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Database1.mdb" & "; Persist Security Info=False;"
You may have missing letters or symbols. Double check it. Thanks!
Give me all Code please :3
thanks (y)
ODB driver manager where ko po mahahanap un ?
bro panu ung debug nd kasi pnkta panu ggwin dun sa error na may debug ? pls pm Asap thanks
Form1 run time error showing
Compile error:
user-defined type not defined
sir pano po ung error msg na " Item cannot be found in the collection corresponding to the requested name or ordinal" salamat po
i got and solve the problem that you can't access ti login, finally you save your work then try to Run... thats why error con.Open
Need help plz
Lots of thanks...(-.*)
You're welcome! :)
error pls help Text1.setfocus error
make sure that the name of your Textbox is correct.
How did you debug the "cnn.open" error? u didnt show it in the video cause you skip it.
I encountered that error because the database file is not on the folder with the vb project. So make sure the database and the project are in the same folder. :)
ClydeLee Ramos i also got prob cnn.Open...Database and Project are already in a same folder?so How? Can you help me please?
+ClydeLee Ramos my database and my project are in the same folder why i have a problem in cnn.Open?
HI all! If you get an ERROR on this line "Public cnn As ADODB.Connection", i got the SOLUTION.
If you have copied the code from the blog, you have copied multiple "_" after the public declaration and before the sub "getconnected", so you have to delete the "_".
showng error in private sub login() this line
rs.Open "select * from user where username ='" & Text1.Text & "'", cnn, adOpenStatic, adLockReadOnly
what is the exact error message
my error is "syntax error in from clause" , in (rs.Open "select * from user where username ='" & Text1.Text & "'", cnn, adOpenStatic, adLockReadOnly)
line
"user" is a reserved word.. try changing the name of your table to "tbluser"
thank you very much sir it really work
you are welcome, sir. :) if you have any questions please don't hesitate to write a comment
sir may error po sa "&"
cnn.Open? what's wrong with that?
bhai tera hi h sahara
Reply po kayo agad kailangan ko po na ito asap..Reply po..
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\RAIN\Desktop\unsuccess username pass\username.mdb;Persist Security Info=False;"
nag dedebug po dun s may module dun s conn.Open pano nyo po naayos un d b po un dn problema nyo dun s video
Ano po yung exact error message?