SQL Statement Not Producing Results
Hi!!
I'm really stuck on this and have been for awhile. I'm hoping to get some help!
I have tired all of the below and got the following error.
"SELECT * FROM Customers WHERE ProductID = " & (Text6.Text) & ";"
Error: Failed getting rowsets from current data source.
"SELECT * FROM Customers WHERE ProductID = " & CLONG(Text6.Text) & ";"
Error: Failed getting rowsets from current data source.
"SELECT * FROM Customers Where ProductID = " & Val(Text6.Text)
Error: Failed getting rowsets from current data source.
What is wrong?? How do I fix it?
I produce a datareport but the sql statement isn't working for displaying only 1 customer. I would like to display the information for one customer. The field that the one customer is based upon is a number which is entered into a text6.text box on a previous form.
Customers is a table name. ProductID is a field in the table. Do I have to say the what form it comes from???
Thanks
SQL Statement Not Working
I have tried the following with the errors listed below....
"select * from Customers where values in(" ' & Text6.Text&'")"
Error: Failed getting rowsets from current data source.
"SELECT * FROM Customers Where ProductID = " & CInt(Text6.Text)
Error: Failed getting rowsets from current data source.
What in the world I'm I doing wrong??? Why is this not working??
InCorrecct Data Report Results
I used all of the above code expect for the line "DataEnviornment1.rs.Command1
Val(text6.text)". I had to change that line to say "DataEnviornment1.rs.Command1
Val(Form1.text6.text)".
I'm not the results that I expected to get from the database. For example, say the customer has 2 orders already in the database and is currently entering in another order and then hits the datareport button. The datareport is only showing the
customers previous 2 orders and does not display the last one just entered.
If I enter a new customer, and hit the datareport button I get a blank DataReport.
I know that the last order goes in to the database by looking at the Access 2000
file just prior to hitting the button to produce the report.
What is wrong? What needs to be changed? Ideas?
Thanks a million!!!!!!!!!!!!!!!!!!!!!!1