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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tonyblazek

    Need web front ends

    Hello all, we have a number of applications based on MSAccess and I've been asked to make them available from the web. They're fairly simple, most just collect and store information without much manipulation. I haven't done much of this and wonder if anyone can recommend any tools and tips...
  2. tonyblazek

    Help with isnull in SQL statement

    Hello Rick, it works great!! Thank you for your time and effort, I can't tell you how big of help you've been. Not only have your solved my problem you've taught me a bunch along the way! Your explanations are wonderful. Again, thanks!! Tony
  3. tonyblazek

    Help with isnull in SQL statement

    Hello Rick, I tried both and I still need all three values to return a record? Got any more tricks up your sleeve? Tony
  4. tonyblazek

    Help with isnull in SQL statement

    Thanks again Terry, it didn't make any difference, I made a new form with the same results. This is driving me crazy and giving me more respect for the db guys. Got any more ideas? Thanks, TB
  5. tonyblazek

    Help with isnull in SQL statement

    Thanks Terry. I made the changes you suggested but didn't realize and additional functionality? The query still requires all 3 values to return a record? I've got the controsl default value set to = null and your SQL seems correct (Access didn't barf on the save)??? Any more ideas? Thanks, Tony
  6. tonyblazek

    Help with isnull in SQL statement

    THANKS, I get it. You say just remove "*", then how do I tell it to replace the null with a wild card? TB
  7. tonyblazek

    Tab stops with subforms

    Hello all, I have a form that has 2 subforms. Does anyone know how to make the tab stop move on to the next subform? Right now once in the first form the tab cycles within the form and won't move onto the next form. Thanks, Tony
  8. tonyblazek

    Help with isnull in SQL statement

    Hello all, a guy who knows nothing about SQL here. I built a query in Access and I would like to modify it so if one or more of the values is null it is replaced with a wild card. Following is the SQL generated by my Access query, SELECT Asset.[Asset ID], Asset.Name, Asset.Description...
  9. tonyblazek

    Parameter query using a form.

    THANKS!!, it works fine. How would you go about making the query work with one of the vaules missing? Right now Access needs all three to find anything. Thanks, Tony
  10. tonyblazek

    Parameter query using a form.

    Hello all, new user here. What is the best way to do this, I need a form with 3 variables selected from combo boxes to launch a query. The out of the box parameter query doesn't gives you any predefined variable choices. Thanks, Tony

Part and Inventory Search

Back
Top