Solved

Overflow Run-time error

Posted on 2003-12-11
1
364 Views
Last Modified: 2010-05-01
Hi,

I would like to get the rest of division very big number with 30 digits
for example 116022440020551020156789252100

- I don't want to represent this numer by any approximation in the form 1.16022440020551E+29
- I received Run-time error '6' Overflow

Code:

Dim rest As Long

rest = 1.16022440020551E+29 Mod 97

If I change

rest = 1.16022440020551E+29 - Int(1.16022440020551E+29 /97) *97

always the result is equal 0
0
Comment
Question by:marekcz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
Smallint earned 125 total points
ID: 9919580

You cannot handle such huge number directly in VB

If you do not want approximations biggest datatype is Currency

with values between – 922.337.203.685.477,5808 and 922.337.203.685.477,5807.


If you need more you must develop your own operators.


Cheers
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month11 days, left to enroll

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question