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!

  • Congratulations strongm 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. Petruche

    Computer "hang" on network connection and disconnection

    Stupid question but are you using a static IP address and if so, could it conflict with your W2K machine's IP address ?
  2. Petruche

    Query from form with the like statement

    "The results are displayed in a datasheet now, which is ok." In other words, the query returns a datasheet view of the results. I thought that answered the question. I also wanted to explain what I wanted to achieve, the more details the better. I'm still learning all this on my own with...
  3. Petruche

    Processes Questions

    See http://www.tasklist.org/ or http://www.liutilities.com/products/wintaskspro/processlibrary/ That should help you Pierre
  4. Petruche

    Query from form with the like statement

    Duane, A little history: I have a drawings table and I want users to be able to search that table based on one or more criterias. I created a form with all the fields contained in that table and a search button that calls the query. The query has the criteria fields set to get data from the...
  5. Petruche

    pc shuts down just before loading the GUI

    Have you tried to boot in safe mode (F8 upon startup)? I agree with Bitfuzzy, reformatting is preferred...WINME is shitty anyway... ;o)
  6. Petruche

    Query from form with the like statement

    All right, additionnal question: There's about 10 fields the user can search on, the problem is that if a field is empty, there are no records returned. How can I have the query return records even if a field is blank ? Thanks Pierre
  7. Petruche

    Query from form with the like statement

    Thanks, I just had to modify it to Like "*" & [Forms]![drawing20041209]![Drawing Number] & "*
  8. Petruche

    Query from form with the like statement

    Hello, I'm building a query based on user input from a form, the problem is that the user has to input the exact query term to retrieve information. It looks like this in the criteria section of my query: [Forms]![drawing20041209]![Drawing Number] Is there a way to use the 'like' statement in...

Part and Inventory Search

Back
Top