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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ejrhodes

  1. ejrhodes

    Copying Format and Column Widths from one worksheet to others

    Hopefully this is an easy one. I am trying to copy the column widths and formatting from my first sheet "sheet 1" and paste it into all other sheets in the workbook. My code is as follows. Any suggestions? Sheets("Sheet1").Range("A:Z").Copy For Each wsheet In wb.Worksheets With wsheet...
  2. ejrhodes

    Public variables?

    Well you both are the man :) THis was driving me absolutely crazy.
  3. ejrhodes

    Public variables?

    CLFlava, as always, you are the man. Thanks for your help, that fixed it.
  4. ejrhodes

    Public variables?

    So then how would I pass the variable to the function?
  5. ejrhodes

    Public variables?

    I tried passing it to my function but I kept getting a type mismatch error. I originally tried: function showQuestion(url2, str, temp3, temp4) { xmlHttp=GetXmlHttpObject() if (xmlHttp==null) { alert ("Browser does not support HTTP Request") return } var url=url2; url=url+"?id="+str...
  6. ejrhodes

    Public variables?

    I am experimenting with AJAX and I am running into an issue. On my page, I have multiple spans with a similar naming convention. eg showtext1, showtext2, showtext3. On the click of another span, I pass my AJAX functions a paramater. One of these parameters is a number that corresponds to the...
  7. ejrhodes

    Making A Text Box Be Transparent

    I had the same problem last week. What I did was use the <div> DHTML tag and set it's innerHTML property using javascript. I then set a hidden form value as well so that I could pass the value to the backend. The Div looks like a label, and the hidden value can't be changed.
  8. ejrhodes

    Undefined Passing Form Value from Child to Parent

    So I got the function to work by referencing the actual form elements. function doThing() { var r = document.selectrfc.rfcid var g = document.selectrfc.rfcselected var v = ""; var w= ""; for ( var i = 0; i < r.length; i++ ) { if (r[i].checked) {...
  9. ejrhodes

    Undefined Passing Form Value from Child to Parent

    I finally was able to attempt this function and I am getting an error that I do not understand. The form HTML is as follows; <html> <head> <title>Modify RFC for site 0095 </title> <LINK REL="stylesheet" TYPE="text/css" HREF="generic.css"> <script language="JavaScript" src="utils.js"></script>...
  10. ejrhodes

    Undefined Passing Form Value from Child to Parent

    This is where I am confused, how would I modify my form such that I can only send the value selected to the form. I see the problem wiht my current form design
  11. ejrhodes

    Undefined Passing Form Value from Child to Parent

    Hey everyone, I am sure this is a simple one, but I am curious if someone can help me debug why I am getting an undefined value when passing a value from the child window to the parent window. On my child window, I have the following code Code: <form name="selectrfc" action=""> <tr> <td...
  12. ejrhodes

    Calculating the difference between 2 days

    Are you serious, the calculation automatically takes into account DST? I was thinking that was it but I kept thinking I was wrong. I wonder if I should exclude this extra-hour, I should reach out to my end user and ask him :)
  13. ejrhodes

    Calculating the difference between 2 days

    Rouding error huh? that sucks :) I guess I have to tell my client to make sure they close all their tickets within 1 month :)
  14. ejrhodes

    Calculating the difference between 2 days

    I now get an error daysInMs is not defined. Will this function solve the extra hour issue I was having? I see how you added the validation for blanks; thanks
  15. ejrhodes

    Calculating the difference between 2 days

    Thanks for the reply, I will read the FAQ on date validation while I eat some lunch. Thanks

Part and Inventory Search

Back
Top