Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by weltergon

  1. weltergon

    sql help

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

    sql help

    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
  3. weltergon

    Query Def

    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
  4. weltergon

    Query Def

    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
  5. weltergon

    Query Def

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

    SQL statement

    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 & "));"
  7. weltergon

    list boxes

    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...
  8. weltergon

    list boxes

    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
  9. weltergon

    Passing values from a form to report

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

    Passing values from a form to report

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

    form/report question

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

    form/report question

    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...
  13. weltergon

    Decimals

    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.
  14. weltergon

    Decimals

    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
  15. weltergon

    I have a form that I am using to up

    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
See more

Part and Inventory Search

Back
Top