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 Chris Miller 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: *

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

    Calculating the difference between 2 days

    if both dates were in the following format mm/dd/yyyy hh:mm Basically, I want to add a validation on both boxes when they are entered to ensure that the data is in the format of mm/dd/yyyy hh:mm Then when I call the duration function, I want to make sure both values are not blank before...
  17. ejrhodes

    Calculating the difference between 2 days

    That looks like it is working much better. Now if I wanted to update the duration box only if both dates were in the following format mm/dd/yyyy hh:mm what would I need to add? if this format validation is difficult, what would I need to add to only update the box if the values are both not...
  18. ejrhodes

    Calculating the difference between 2 days

    With some help, I wrote this simple function which takes the 2 values of text boxes and calculates the difference. The problem is the time calculation is not always correct. Any insight? <HTML> <HEAD> <TITLE>Ticket Tracker</TITLE> <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function...
  19. ejrhodes

    Using Javascript to Validate Format of Text Box

    I have a text box on my form that needs to be in the following format (the leading 0 is not required for mm or dd) mm/dd/yyyy hh:mm The hh:mm is optional, but if they put a time value in, it should be in that format. Can someone provide me with a function I can call onblur of the textbox that...
  20. ejrhodes

    Lag in Link Table Refresh

    Guys, I have an ODBC connection opened in Access which links to an Oracle table. It seems that there is a 20 minute delay between the change being made in Oracle and the data being updated in Access. Is there an ODBC setting that I can change to push the update quicker? Is there something I...

Part and Inventory Search

Back
Top