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?
That's okay. Just one thought. I get a undetermined string error when I try to use Dim as when using VB Script.
Say for example when I use Dim fso as FileSystemObject, the error occurs.
Is there a way to get around that?
Thanks for being patient. What I want to do is make the file look like this.
96022 Singles: 12/13/2004 97 20,177 90 20,267 4,281,989.21 20,177 90 20,267 4,281,989.21 17,608 2,569
96022 Multiples: 12/13/2004 14 603 2 605 638,054.48 966 4 970 638,054.48 785 181
96022 Checks Only: 12/13/2004 26...
What I posted is what the file looks like after it write it back to the browser. Here is what it looks like before that happens. I must warn you. It's a mess.
Formatted File
Singles: 97 20,177 90 20,267 4,281,989.21 20,177 90 20,267 4,281,989.21 17,608...
As you can see below I have a text file that I'm trying to import. What I want to do is rip the customer's box number from the botton line, say 96022 as shown in the text file, and put it at the beginning of each line item for that customer and so on. Below the text file is the script I'm using...
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.