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!

Search results for query: *

  1. joeconway

    Wildcard for a Currency Field

    I mean that i have a search form for entering the variables for querying a database and for the price field i have this code which keeps giving a type mismatch: txtprice.SetFocus If txtprice.Text = "" then txtprice.Text = "*" I tried using "@" but it didnt work
  2. joeconway

    Wildcard for a Currency Field

    This really is a case of me being stupid but I don't know and really cannot find anywhere what Wildcard to use for a currency field, nothing seems to be working:S thanks
  3. joeconway

    "Syntax error in from statement" while using SQL in VB6

    i have a very simple couple of lines of code: sql = "SELECT Itemid FROM [tblstock]; WHERE itemid = txtitemid.text" adostock.RecordSource = sql adostock.Refresh and i keep getting the error in the subject line. I really can't understand the problem because i don't see what else i could put in...
  4. joeconway

    I dont know how to ignore null fields on a search form...

    my problem is basically as the title suggests. I havea search form with multiple text boxes in, when I run the query i need it to check to see if the text box is empty and if not add it to the filtering criteria. Any help would be much appreciated because I'm stumped

Part and Inventory Search

Back
Top