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 Wanet Telecoms Ltd 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
  • Content: Threads
  • Order by date
  1. 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
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. 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...

Part and Inventory Search

Back
Top