Search results for query: *

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

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

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

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

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

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;

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

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

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

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