Search results for query: *

That didn't work...I believe the parentheses are needed. any other ideas? Thanks

Am I doing something wron, its pulling everything up in the table vs. everything that the variable stItems is equal to: strWhere = strWhere "(((tblWorkProductText.WorkProductName)='" & strItem & "'))" my sql statement is a simple select * from table... Thanks

Well I need to run a query based off of selections made from a list box so this needs to be a sql statement...? I am using this for reporting purposes only and I am trying to build a sql statement....Any help? Thanks

Well I tried the runSQL statement but I kept getting an error. All I need is to retrieve records....I am not updating or anything like that. Heres the error I get: a runSQL action requires an argument consisting of a SQL Statement, any ideas as to what i am doing wrong?? Thanks

Hi, What is the code to run a select query that has been assigned to a string variable within the current DB?

HI, If strItems= "conceptual" what is worng with the following code? its not recognizing the where statement... strWorkProductsSQL = strItems2 strFullSQL = "SELECT * FROM tblWorkProductText WHERE (((tblWorkProductText.WorkProductName)=" & strWorkProductsSQL & "));"

Thank You very much. This works; however it retrieves just the row number is there anyway I can retrieve the actual data for example if I select the first option in the list box the code returns 1 and the first option is Concept...is there anyway I can get it to return Concept instead of the...

Hi, How can I concatenate all selected items in a listbox and assign them to a string variable, in order to form a select statement? Thanks

Thanks, But what if I am using check boxes and they can choose mutiple criteria?

How can I pass values chosen on a form to use in a query that a report is based off of? Thanks

Thank You, Where do place this line of code? Will this line of code pass these value onto my query as parameters? Thanks

I am trying to create a form with some options on it that are check boxes, so if option1 is checked and I go to click on a submit button on the form, those values will be used to generate a report and some text that is stored in another table will be displayed depending on which option was...

What does that mean, I have set it to decimal, long integer, integer etc. I have set the format to general, fixed etc. nothing seems to work.

I am using Office XP and when I enter in a decimal it keeps getting rounded to up, so if enter 5.5, when I click off the field it shows up as 6. I've tried everything and I am not sure why its doing this,can anyone help? Thanks in advance

I am using access 2000, and I receive and error in the line that has docmd.findfirst... The error is that the data member cannot be found. Is this something to do with access 2000? Thanks in advance

Hi, I am using Access 2000 I believe it looks like it is version 9.0. I actually do need the requery so I can see the refreshed data. Is there anyway around this? thanks fo your help.

I have a form that I am using to update a table with information. The form is bound to a query. Here is the code behind my update button This is the only code I have: Private Sub cmdUpdate_Click() On Error GoTo Err_cmdUpdate_Click Dim stDocName As String Dim var As String...

I only have update code, does anyone know how within this code I can save my place in the recordset, do a requery, and go back to the same record. The form is fed from a query. Thanks in advance

I tried this and its not working. I was receiving an error on the line that sets up the DAO connection so I commented it out and it ran without error but its still going to the first record. also this form is running off of a query and I am not sure which key should be the primary key, does it...

Thank you for replying, if its possible can I see an example. Thank you for your help.