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 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. dmhayes

    Not see the dashs in a querry?

    I did not run my one. But i ran your one that you did and got an error... TO complex to be evaluated use variables... regards
  2. dmhayes

    Not see the dashs in a querry?

    This is the code in sql WHERE (((PARTS.[PART NUMBER]) Like [Please enter Part No] & '*')) use this one WHERE Replace(((PARTS.[PART NUMBER]'-',")Like [Please enter Part No] & '*')) thank you for help
  3. dmhayes

    Not see the dashs in a querry?

    i have a database that searchs for part numbers and in these feilds are also dashs and dots can i tell the querry or code to not worry about the dashs. So it will give me a result of everything that matches the number and text . Not worrying about the dash that was type in my the user. Regards Me
  4. dmhayes

    help with a criteria

    I have created a database with parts in it... to find every part that needs to be ordered. table partid partnumber partdesc minqty maxqty in a querry i put for the criteria > ????? under the minqty should this work..
  5. dmhayes

    How can i search two or third feilds in the same table with a querry

    I have a database with one table in it I have two feilds i want to be able to search with one querry. PARTNUMBER AND ALTNUMBER AND NSNNUMBER
  6. dmhayes

    runtime error 6 overflow

    Thank you very much. Is there a way in which to put letters in front of autonumbers or automate that feild better. regards donna
  7. dmhayes

    runtime error 6 overflow

    I have this happening in my access database . i am new to access and have aviheive alot from errors... one more thing the record id which is a autonumber has now given me (335648925) not smaller numbers. Private Sub cmdPickPart_Click() Dim strPart As String strPart =...

Part and Inventory Search

Back
Top