Search results for query: *

Thanks!!!!

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

Thanks so Much!!!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Why can't you return it as a variant?