ganatra
asked on
Access Login Form
hi .. when i'm running this code. i'm getting this error.. "No value given for one or more required parameters." i have two text boxes in my form with name as username & password . and just a command button. the table is patron with cardnumber and password as fields in it.
here is the code.. plz help..
Private Sub Command9_Click()
On Error GoTo Err_Command9_Click
Dim con As Object
Dim rs As Object
Dim stSql As String
Set con = Application.CurrentProject .Connectio n
stSql = "SELECT * FROM [Patron]"
stSql = stSql & " WHERE [CardNumber]= Forms!test1!usernumber & [Password] = Forms!test1!password;"
Set rs = CreateObject("ADODB.Record set")
rs.Open stSql, con, 1 ' 1 = adOpenKeyset
If (rs.EOF) Then
MsgBox "Command not available."
Else
MsgBox "Command available."
End If
rs.Close
Set rs = Nothing
Set con = Nothing
Exit_Command9_Click:
Exit Sub
Err_Command9_Click:
MsgBox Err.Description
Resume Exit_Command9_Click
End Sub
here is the code.. plz help..
Private Sub Command9_Click()
On Error GoTo Err_Command9_Click
Dim con As Object
Dim rs As Object
Dim stSql As String
Set con = Application.CurrentProject
stSql = "SELECT * FROM [Patron]"
stSql = stSql & " WHERE [CardNumber]= Forms!test1!usernumber & [Password] = Forms!test1!password;"
Set rs = CreateObject("ADODB.Record
rs.Open stSql, con, 1 ' 1 = adOpenKeyset
If (rs.EOF) Then
MsgBox "Command not available."
Else
MsgBox "Command available."
End If
rs.Close
Set rs = Nothing
Set con = Nothing
Exit_Command9_Click:
Exit Sub
Err_Command9_Click:
MsgBox Err.Description
Resume Exit_Command9_Click
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
btw you forgot the AND in between.. :)
if i need some more help i'll contact u.. thx..
if i need some more help i'll contact u.. thx..
oh yes... sorry
Anytime mate.
Anytime mate.
ASKER
hope u r there,
how will i write a query based on the form parameters,
the scenario is that i want to retrieve data from a table based on two parameters,
keyword and author.
i have this query working..
SELECT *
FROM Book
WHERE (((Book.Author)=[Forms]![M ainForm]![ keyword])) ;
Now what i need is that this Book.Author should also be read from the form. the form has a combo box name searchBooksCombo with values Author, Title , Description in it. so i want the query to select the Where from the Combo box.
hope you got me..
i'll give 50 points for this also..
give it a try..
i'm waiting..
how will i write a query based on the form parameters,
the scenario is that i want to retrieve data from a table based on two parameters,
keyword and author.
i have this query working..
SELECT *
FROM Book
WHERE (((Book.Author)=[Forms]![M
Now what i need is that this Book.Author should also be read from the form. the form has a combo box name searchBooksCombo with values Author, Title , Description in it. so i want the query to select the Where from the Combo box.
hope you got me..
i'll give 50 points for this also..
give it a try..
i'm waiting..
is the form open?
oh sorry, i see you hav it working.. giveme a minute
WHERE (((Book.Author)=[Forms]![M ainForm]![ keyword])) and (((book.author) = [forms]![mainform]![search BooksCombo ]));
also, make sure your "bound column" is set to the author column for this to work
DAve
DAve
ASKER
no .. i think you didnt got me..
i dont need book.author hardcoded..
simply say..
SELECT *
FROM Book
WHERE (((Book.xxxxxxxxxxxxxxx)=[ Forms]![Ma inForm]![k eyword]));
this xxxxxxxxxxxxxx should be read from the form combo box. it can be author, genre, description.
hope you got me now..
plz help..
i dont need book.author hardcoded..
simply say..
SELECT *
FROM Book
WHERE (((Book.xxxxxxxxxxxxxxx)=[
this xxxxxxxxxxxxxx should be read from the form combo box. it can be author, genre, description.
hope you got me now..
plz help..
aaaahhh.....
now this is either going to take some vb to dynamically change the querydef object...
Add a refrence to Microsoft DAO Obj Lirary 3.?? - To do this in the VB window, select Tools - Refrences and tick it from the list
now this code wil do it - add it to the form (MainForm) i assume - say from the command button you use to execute it
private sub cmdMyButton_click()
Dim qry As QueryDef
Set qry = CurrentDb.QueryDefs("qSelM yQuery") ' change name to your query name
qry.SQL = "SELECT * FROM Book where " & Nz(Me.cboMyCombo, "Author") & " = '" & Me.keyword & "';"
end sub
hope this helps. if you'd rather create a temp qry, this can be done, depends on what you are doing with it
dave
now this is either going to take some vb to dynamically change the querydef object...
Add a refrence to Microsoft DAO Obj Lirary 3.?? - To do this in the VB window, select Tools - Refrences and tick it from the list
now this code wil do it - add it to the form (MainForm) i assume - say from the command button you use to execute it
private sub cmdMyButton_click()
Dim qry As QueryDef
Set qry = CurrentDb.QueryDefs("qSelM
qry.SQL = "SELECT * FROM Book where " & Nz(Me.cboMyCombo, "Author") & " = '" & Me.keyword & "';"
end sub
hope this helps. if you'd rather create a temp qry, this can be done, depends on what you are doing with it
dave
now this is either going to take some vb to dynamically change the querydef object...
should be
now this is going to take some vb to dynamically change the querydef object...
Dave
should be
now this is going to take some vb to dynamically change the querydef object...
Dave
also if the user didnt select anything from the combo box, i set it to author...
Dave
Dave
ASKER
Dave,
the query is changing dynamically, but the form is not showing the results when i click on the command button. i have place a datasheet on the main form . the datasheet is based on the search query. when i put the keyword and select author from combo, nothing happens at that moment. when i open the form again, the datasheet is showing the results of the query. can this datasheet show dynamic results?
i'm posting a question to give u the 50 points i promised..
ok..
thx..
waiting for ur reply..
the query is changing dynamically, but the form is not showing the results when i click on the command button. i have place a datasheet on the main form . the datasheet is based on the search query. when i put the keyword and select author from combo, nothing happens at that moment. when i open the form again, the datasheet is showing the results of the query. can this datasheet show dynamic results?
i'm posting a question to give u the 50 points i promised..
ok..
thx..
waiting for ur reply..
can you post the full code you are using at the moment. It should work, its very hard to debug things like this without the actual db at hand.
Its about 6:30pm here and im going out for the night, ill get back to you tomorrow at work (about 7am - T minus 11hrs)
Dave
Its about 6:30pm here and im going out for the night, ill get back to you tomorrow at work (about 7am - T minus 11hrs)
Dave
ASKER
Hi Flavo,
I want to give you the 50 points i promised.. should i post a new question for it? hope you get this message.
regards,
I want to give you the 50 points i promised.. should i post a new question for it? hope you get this message.
regards,
yeah, do that.
Did you get it all working??
Dave
Did you get it all working??
Dave
ASKER
Hi Flavo,
Sorry i was away and couldnt reply you.. listen i have an open question in the java category that i want to close.. i'm not getting any good answers ..its worth 50 points.. here is the link..
https://www.experts-exchange.com/questions/21094629/help-with-JPopUpMenu-JList.html
i can award you these points.... but still if you need points in MSAcces category i will have to post a new question.. if you need the java 50 points ..post a comment on it and i'll accept it rite now..
reply,
...
Sorry i was away and couldnt reply you.. listen i have an open question in the java category that i want to close.. i'm not getting any good answers ..its worth 50 points.. here is the link..
https://www.experts-exchange.com/questions/21094629/help-with-JPopUpMenu-JList.html
i can award you these points.... but still if you need points in MSAcces category i will have to post a new question.. if you need the java 50 points ..post a comment on it and i'll accept it rite now..
reply,
...
Good luck, and happy coding
Dave