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 wOOdy-Soft 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: *

  • Users: hawley
  • Content: Threads
  • Order by date
  1. hawley

    Suggestion needed - reference cell looks at one range then see if any

    My brain is out of ideas so was hoping someone else had a thought or could nudge me in the right direction. Here is what will happen: 1. Data is dumped from a database and will be put in the Data Worksheet (columns A-D). 2. Column D from the Data worksheet will be copied and paste into the...
  2. hawley

    Validation List Cutting off Values

    I have a sheet that contains values that I will use for the data validation list. When I run this code the list cuts off. Is there some sort of restriction when creating the validate list for a drop down? My list is not reaching 65000 characters which is the string cut off. Code: Dim...
  3. hawley

    Using a list passed from an Oracle COBOL pgm to a DB2 COBOL pgm

    This may belong in the DB2 forum but I am using this with COBOL so put it here. I have a fun problem. I have a COBOL program that is retriving a list of numbers from an Oracle database. Each time it retrieves a new number it puts that number in a comma delimited string with single quotes...
  4. hawley

    xsl:if test=

    I have just gotten thrown into html, xml and xsl code so please ignore my basic knowledge. I have a content management system that creates html, xml and xsl code. It is a tool where a user will enter data into fields and then an html page will be created. When they enter data and enter...
    • hawley
    • Thread
    • Replies: 4
    • Forum: XML
  5. hawley

    creating a new class w/ multiple items

    I am just learning html and style sheets so I am not sure of how everything works. I am trying to create a style sheet with the following class: body.standard_format { background-color: #ffffff; margin-left: 0; margin-top: 0; margin-height: 0; margin-width: 0; font-family: verdana...
  6. hawley

    PB7 -> CheckBox ThirdState

    I hope this is the correct area to post this question. If not sorry, if so please help. I have looked every where and can find nothing. I am trying to work with making a check box a halfchecked check. By doing this I need to use the ThirdState Property. The way I have it set up is 0=off...
  7. hawley

    convert month name

    If you have a string that is equal to "June" how do you convert that to the month number, 06. I have found stuff on getmonth and such but I don't have the whole date. Just the month name. Thanks!!!
  8. hawley

    download excel from internet

    HELP!!!!! We have just switched over from OS 9 and Netscape to OS X and Internet Explorer. I have a page on the internet explorer that creates a text file. Then there is another link on that page that will open excel and give me a list of text files to open through excel. The problem is some...
  9. hawley

    changing a date

    Is it possible to convert a date 05/15/2004 to 05/01/2004 in a select statement? Thanks in advance!!!
  10. hawley

    radio button

    I am creating three radio buttons. "Submitted", "Not Submitted", and "Submitted & Not Submitted". I have two problems. The first is that "Submitted & Not Submitted" come out like "Submitted _Not Submitted". How do I make the "&" appear and not the "_"? Second is I want "Submitted & Not...
  11. hawley

    rename dropdown box

    I am using Excel 97. From the Forms toolbar I added a combo box to the excel sheet. It gives me a default name of "Drop Down 2". I want to change this name but not sure how. I have two sheets that look identical but the names of some of the drop downs are different and I need to make them...
  12. hawley

    No Return() or Halt() function?????

    I have created an excel template that has a menu option to open another template and have one user out of about 50 getting an error. The wierd thing is she can be doing nothing but staring at the screen and get this error. I have had desktop look at her computer and she is updated with all the...
  13. hawley

    notify file already open

    In an excel template there is a menu option that opens the "open file" dialog box. I choose a file from there and click okay. If someone else has it open there is no message saying so but the title bar has read only. I want the message to appear warning the user that so and so already has it...
  14. hawley

    seconds past midnight

    I have a select statement that is bringing back date values. The problem is I want it in a db2 format. I know how to get the extra seconds past midnight but I need one more zero added on. Does anyone know a way to add an extra 0 to the end? Here is my select statement: SELECT DISTINCT...
  15. hawley

    using oracle with cobol

    I have a cobol program and trying to use oracle. I am getting an error that I don't understand. Can anyone help? I am passing in data from a control card. See below for layout. 01 CC-CONTROL-CARD. 05 CC-RUN-DATE. 10 CC-RUN-DATE-CC PIC X(02). 10...
  16. hawley

    combine an outside table and a new table

    I have a table that I got from Oracle. I did the "Get External Data". What I want to do is add and take away some fields and make a new table. I want to update the new table with info from Oracle when it changes. Any ideas? Here is an example of what I am talking about. I want...

Part and Inventory Search

Back
Top