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

    Nested IF (with other complications)

    I am using the following to return an individual: =IF(ISERROR(INDEX(B1:I36,SMALL(IF(C1:C36=B76,ROW(C1:C36)),ROW(1:1)),1)),"----------",INDEX(B1:I36,SMALL(IF(C1:C36=B76,ROW(C1:C36)),ROW(1:1)),1)) This works fine for one column (C) - but I would like it to work over the range of columns C to I...
  2. tradewise

    Styling xml

    Thanks Chris, tried it - no joy. wrt XSLT, do you know of any good resource sites worth a look at?
  3. tradewise

    Styling xml

    Any help on applying style to TableName (in this case AIRCRAFT) would be most appreciated: ...extract from source code ..... <?xml version="1.0" encoding="UTF-16"?> <?xml-stylesheet type="text/css" href="test.css" ?> <XML_Transfer> <Table TableName="AIRCRAFT"> <Fields> <Field>...
  4. tradewise

    Search engine returns

    Sorry the code that I last posted works a treat strSQL = "SELECT * " strSQL = strSQL & "FROM tblsyse " strSQL = strSQL & "WHERE ReferenceNumber=" & Request.Form("senum") & " " strSQL = strSQL & "ORDER BY tblsyse.ReferenceNumber;" thanks again for your input 'til the next time ...........
  5. tradewise

    Search engine returns

    Tried yours - got data mismatch took single quotes out as its not a string code used as follows: strSQL = "SELECT * " strSQL = strSQL & "FROM tblsyse " strSQL = strSQL & "WHERE ReferenceNumber=" & Request.Form("senum") & " " strSQL = strSQL & "ORDER BY tblsyse.ReferenceNumber;" thanks for...
  6. tradewise

    Search engine returns

    Thanks for your speedy response. Here's the query ... strSQL = "SELECT *" strSQL = strSQL & " FROM tblsyse" strSQL = strSQL & " WHERE ReferenceNumber like "& "'%" & Request.Form("senum") & "%'" strSQL = strSQL & " ORDER BY tblsyse.ReferenceNumber;
  7. tradewise

    Search engine returns

    I have created a keyword search and it works ... to a certain degree. Let me explain. If I want to search for a particular record e.g. 27 I enter 27 in the search text field and press the button. I expect to see record 27 returned. What happens is that record 27 is returned .... along with...
  8. tradewise

    display boolean on webpage

    damber it works a treat I'll have this one tucked away for future use. Thanks a lot
  9. tradewise

    display boolean on webpage

    I have an access database that has a yes/no field. What I am attempting is to display the result of this field in a checkbox on a webpage. If I use a text box it displays either 'true' or 'false' depending on the value in the database. As soon as I change it to a checkbox it just does nothing...
  10. tradewise

    Table design and normalization

    I want to display skill codes. The codes must be applicable to multiple Trainee types, Locations, Rooms and Trainers eg Code - A1 Code Applies To - Archery Description - Do This Reference Material - Book A Trainee - Men, Women, Children Skill Level - Novice Location - Here, There, Everywhere...

Part and Inventory Search

Back
Top