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 Rhinorhino 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: tennis
  • Order by date
  1. tennis

    blanks coming in as zeros

    Thanks!!!!
  2. tennis

    blanks coming in as zeros

    Hello, I have a linked worksheet where the table data has data that contains blanks; however, when I link that to a formatted worksheet the blanks now appear as zeros. How do I link that data and have the blank fields come in as blanks.....not zeros? Thank you
  3. tennis

    calculated field

    Thanks so Much!!!
  4. tennis

    calculated field

    Thanks for your response. Sorry for the confusion. I do not have the total for TotalMiles. Right now the user is manually subtracting the amount and then entering it in. I would like for the program to automatically fill in the field once Mile_In and Mile_Out is entered. I was hoping to not...
  5. tennis

    calculated field

    Hello, I have a form that has 3 fields, Mile_In, Mile_Out and TotalMiles, where TotalMiles = Mile_Out - Mile_In. Unfortunately the database was set up with TotalMiles as a field in the database. On the Properties, TotalMiles is a Control Source linked directly to the field in the database. Is...
  6. tennis

    text box field won't update

    Thank you for your response. Hmmm, I added the statement and it still isn't updating the CityTax field. Any more ideas??? Thanks again
  7. tennis

    text box field won't update

    Hello, I have a form that has 2 fields, City and CityTax. I have a table that lists all the cities with their corresponding tax rates. I would like to have a drop-down list on the City field where the user can choose the city and then the CityTax Rate is automatically filled in. For the City...
  8. tennis

    optional lookup field

    I have a field - city , which is located on the table Customers - on a form. I have another table that lists all of the cities in Illinois. I would like to have an optional drop down list for the city field where the user can select from a list of cities from the city table or enter in their...
  9. tennis

    Hello, I have the following equati

    Hello, I have the following equation in the control source and it works: =DSum(&quot;[Amt of Dues]&quot;,&quot;City&quot;,&quot;[Amt Paid]=0&quot;) Also, the following works: =DSum(&quot;[Amt of Dues]&quot;,&quot;City&quot;,&quot; [City]![Date Paid]<=&quot; & &quot;[Reports]![Combined Dues...
  10. tennis

    printing a hidden field

    Hello, I believe this is a very easy task but I can't seem to make it work. I have a hidden value in my html page and I just want to display it: <form name=&quot;parm&quot; ...... <input type=&quot;hidden&quot; name=&quot;state&quot; value=&quot;MT&quot;> I am trying to use alert...
  11. tennis

    extracting portion of URL

    Thank you for your reply. Silly....Easy question. How do I get the URL if it is a variable?? Something like location.search.????? Many thanks
  12. tennis

    extracting portion of URL

    Hi, I need to extract a portion of a URL and use it as a variable to create another URL. If my URL is: http://xyz.abc/file.html?geo=st&state=WA&year=1999 How do I just extract the state portion of the url? Thanks in advance
  13. tennis

    loading multiple values from a select list

    Thanks, I think I figured it out -- I was sending the index vs. theList.
  14. tennis

    loading multiple values from a select list

    Hi, I have an html form that has multiple select options and I am trying to pass all of the selections into a generic JavaScript function to build a URL The call to the javascript is as follows: <input type=&quot;button&quot; name=&quot;submit&quot; value=&quot;Select County&quot...
  15. tennis

    Using referrer in a form to assign a hidden value

    Hi; I have a form in an html document with a hidden field. I would like to assign that field(referring_page) the value of the referring document. The form emails the different field values back to the customer. Here is the non-working code I have so far: <script...
  16. tennis

    changing/resetting a value in a form

    I have an html form that contains a couple of select lists. By default both lists are set to &quot;ALL&quot; and if a user changes a value (using onchange ) some comparisons with the value are made. For instance if one of the select lists is country and another is city , if a user selects a city...
  17. tennis

    Not enough parameters

    Do you ever dim a connection object? The &quot;Con&quot; that you use?
  18. tennis

    Capturing return string into 1 variable

    Why can't you return it as a variant?

Part and Inventory Search

Back
Top