Hello everyone! :-)
This is the first time this has happened to me. I have a long
variable I am trying to put a big number in and I guess it's too
big. Here's what's going on...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
TempVar = Mid(RecordIn, 57, 12) 'This number is 012182576785
TotalHeaderWages = CLng(TempVar)
This generates overflow error.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
What am I to do here? I did a little look through the helps and saw
one example where they said an error being generated
by "number=2000*36" could be avoided by writing it as "number=clng
(2000)*36" but I don't see how I can change this to work. originally
it was all one line i.e. totalheaderwages=clng(mid(recordin,57,12)),
and before that I was using VAL instead of CLNG but I still get the
error. How am I supposed to handle bigger numbers? This could have
been a bigger problem but I can get by for the moment... but
eventually I need to find a way to handle this situation.
Thanks in advance!
[C]
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hn87mci/M=362329.6886308.7839368.1510227/D=groups/S=1705115364:TM/Y=YAHOO/EXP=1122995967/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~->
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
