Search results for query: *

Hi; I have a workbook with three sheets - Search Form, Results and Data Table. The search form allows the user to type in information into one of ten fields. Each field is aasociated with a column in the data table ; any hits go into the results sheet. The header row of the data table goes in...

Hi; I tried your modifications and it seemed to work - partially. WI was a little surprised to hear that every cell had to be occupied. I was trying to use a modified version of the code I found on http://www.meadinkent.uk/xlfilter.htmwhich seemed to indicated that filling all cells wasn't...

I tried to run the advanced filter manually with the following: List range: Data!$A$2:$H$11 Criteria Range: Results!$B$2:$I$5 Copy to: Results!$B$9:$I$1000 It produced this message: Extract range has missing or invalid field name. I looked at all fields and they seem to be intact. Any help...

Hi; I tried your idea for tracking CriteriaRange.address and Worksheets("Data").Range(DataRng).address. I was able to figure a few things out and I seem to get all unique rows. This works if I put one value in one column or multiple values in one column so that they are ORed together...

Hi; I have a workbook with two sheets: Data and Results. My search button on the Results sheet will see what criteria has been entered in the criteria section of Results and then display rows in the Data sheet that match the Criteria. The matching rows are displayed in the Result section of...

DataRng = "A2:H2" ' range of column headers for Data table

Hi; I have a workbook with two sheets: Data and Results. My search button on the results sheet when pressed will see what criteria has been entered in the criteria section of Results and then display matches in Data in the Result section of the Result sheet. I have the following declarations...

Hi; Thanks very much for the response. I was notified that you had also sent a response to my thread entitiled "pass a CSS to ta webpage and launch it". I can't seem to find the response. Can you resend it as a reply to this message? Thanks

Hi; I'm creating an application in Frontpage with javascript code that will create a form. I want the form data (2 fields - username and password) passed to an MS Access database (one table consisting of username, password and stylesheet)with the stylesheet field value extracted and sent to a...

Hi; I'm creating some javascript code in frontpage so that I can retrieve some info from an MS Access database. The database has three fields: username,password and stylesheet. I'm trying to retrieve the stylesheet value by having a user input their username and password in a form. I then...

Hi; I have an excel application of seven textboxes, asubmit button and a reset button on one sheet of a workbook. Another sheet has the data to be searched and another sheet will hold the results. I can enter info on one textbox and after clicking the submit button the result will appear. My...

Hi; I have an excel application of seven textboxes, asubmit button and a reset button on one sheet of a workbook. Another sheet has the data to be searched and another sheet will hold the results. I can enter info on one textbox and after clicking the submit button the result will appear. My...

Hi; I am trying to trace a variable which is an array element. The element holds a hexadecimal number which can be changed. If the user changes it, I need to make sure that a valid hex number was put in. Instead of getting the value of the element, I am getting the name of the element. Pieces...