Sorry, It might help to see everything I'm trying to do. Here is the code along with the recordset that I'm trying to convert.
Recordset
Do Until RSData1.EOF
Dim CashC1, Cash1Legal
CashC1 = CashC1 + RSData1("CashAmount1")
AccountOne = RSData1("AccountNumber")
Group1 = RSData1("Custgroups")...
Sheco, thanks for the response. I changed all the end functions to exit functions and now there are no more error messages. Just one more question? How do I display the results? I know it should be simple but I'm missing it somehow.
Thanks for the quick response. I made the needed change but I'm getting a Expected Statement error at the last line 267 which is the End Function line. What's wrong?
I was directed to this script that converts numerical amounts into words using Visual Basic. I'm trying to make some changes to it so that I can use it in ASP/VBScript but with no success. The variable I'm trying to convert and display is CashC1. I'm unfamiliar with functions such as ParsChunk...
Thanks for the great response Tarwin. I've got it working and it converts all dollar amounts to the corresponding english word. But how do I get it to recognize the cents For example. Getting $120.45 to convert to One Hundred Twenty dollars and forty five cents?
Here is what I have
Dim...
Does anyone remeber how to remove the page header and footer in a page so that when I print a report you don't see Page 1 of 2 at the head of the page and the name of the page at the bottom? Example http://172 etc.
I hope someone can help me. I was directed to a script that converts a numeric amount to text. As you can see it's in VB. I want to convert the SQL variable called CashAmount to text. Is there anyone out there that could give me a hand in changing the script so that I can use it in ASP?
set...
Say I have a page that displays the number $456.28. Is there a script that will allow me to convert this to Four Hundred Fifty Six Dollars and Twenty Eight cents? Has anyone seen anything like that?
Does anyone remember how to post to a checkbox field? In Access the field value is Yes/No. I've tried using Request.Form instead of CleanInput but with no success.
Here is how I'm trying to do it but I'm getting a datatype mismatch in criteria error:
Option Explicit
Function...
Is there a way to control print settings on the home server for a web page so that when someone on another PC brings my page up and trys to print it the entire page will be set to fit to page?
Does anyone remember how to flatten the edges of a text box so that they don't appear to be raised? I'm trying to make it that the box doesn't stand out so much on a form.
<input type="text" name="txtBoxNumber_n" size="8" maxlength="7"></td>
I'm able to use the function: application/vnd.ms-excel to open excel on a Windows 2000 machine but on an XP machine it brings up excel but displays no data. Is there a different script for XP?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.