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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
freezing the top row of a sheet with a macro
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...- jjfjr
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel advancedfilter macro returning same row every time
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...- jjfjr
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
excel advancedfilter blowing up with a "1004" error
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...- jjfjr
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
pass values from a form to a stored procedure
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...- jjfjr
- Thread
- Replies: 3
- Forum: Javascript
-
creating a SQL SELECTstatement in javascript
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...- jjfjr
- Thread
- Replies: 2
- Forum: Javascript
-
Trying to search on more than one column in excel
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...- jjfjr
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
searching in more than one textbox in excel
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...- jjfjr
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
trace variable : trying to get value of array element
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...
