[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Overflow Error on Calculation

Posted on 2008-06-15
17
Medium Priority
?
572 Views
Last Modified: 2011-10-19
Morning all,

Trying to calculate the wieight on a punch in Microsoft Access (form) in order to calculate the transport charge.

I'm getting an overflow on the following line of code. Can anyone help me overcome this?

w_calc = 3.14159265 * (Me.ShankDiameter / 10) ^ 2 * Me.OverallLength * 7.8 / 10 * 4 * 1000

shankdiameter = 4
overalllength = 80

Thanks
Sean

0
Comment
Question by:SeanNij
[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
  • 7
  • 5
  • 4
  • +1
17 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21791146
Hi SeanNij,

What Data_Type are w_calc ,shankdiameter & overalllength ? (integer,single etc)


Gary
0
 
LVL 1

Author Comment

by:SeanNij
ID: 21791184
w_calc is long
shankdiameter is single
overlength is single
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 1200 total points
ID: 21791211
try w_calc = CLNG(3.14159265 * (Me.ShankDiameter / 10) ^ 2 * Me.OverallLength * 7.8 / 10 * 4 * 1000)
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Comment

by:SeanNij
ID: 21791444
nope - same error
0
 
LVL 17

Assisted Solution

by:Natchiket
Natchiket earned 400 total points
ID: 21791636
hmmm looks like maybe the 2 * Me.OverallLength * 7.8 / 10 * 4 * 1000 is getting multiplied together before the power is applied giving a large exponential whereas presumably it's (shankdiameter/2) squared.
try

3.14159265 * ((Me.ShankDiameter / 10) ^ 2) * Me.OverallLength * 7.8 / 10 * 4 * 1000)
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 400 total points
ID: 21791737
w-calc is ?long?
Are you intentionally trying to lose the decimal part?

But I can't reproduce the problem in A2003.
All I'm doing is  this...

Private Sub Command4_Click()
Dim wcalc As Long
wcalc = 3.14159265 * (Me.Shankdiameter / 10) ^ 2 * Me.OverallLength * 7.8 / 10 * 4 * 1000
MsgBox wcalc
End Sub

msgbox shows...125463
0
 
LVL 1

Author Comment

by:SeanNij
ID: 21791879
Me.WeightPP = 3.14159265 * (Me.ShankDiameter / 10) ^ 2 * Me.OverallLength * 7.8 / (10 * 4 * 1000)
0
 
LVL 77

Expert Comment

by:peter57r
ID: 21792090
That works for me as well.

Go into the immediate pane and try:

?3.14159265 * (4 / 10) ^ 2 *80 * 7.8 / (10 * 4 * 1000)
0
 
LVL 1

Author Comment

by:SeanNij
ID: 21792324
RunTime Error '6'
Overflow i use immediate window
0
 
LVL 77

Expert Comment

by:peter57r
ID: 21792381
How peculiar...see attached

You are definitely using Access 2003?


Doc6.doc
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21792438
Check that you don't have any missing references
0
 
LVL 1

Author Comment

by:SeanNij
ID: 21792474
brand new database
started from scratch yesterday on it.

what i did was uninstall office service pack 3 yesterday, cuase since i installed it my Access keeps crashing in weird places.

since uninstalling been fine....except for this error now....
0
 
LVL 1

Author Comment

by:SeanNij
ID: 21792478
hmmm

Me.WeightPP = 3.14159265 * (Me.ShankDiameter / 10) ^ 2 * Me.OverallLength * 7.8 / (10 * 4 * CLng(1000))

works....

WTF!!!!!!!!!!!!!
0
 
LVL 77

Expert Comment

by:peter57r
ID: 21792507
That might be an explanation.  I never moved to SP3 because of all the problems reported as soon as it was issued.
So my examples are all on sp2.


0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21792582
You should install the hotfix for SP3
http://support.microsoft.com/kb/945674
0
 
LVL 1

Author Closing Comment

by:SeanNij
ID: 31467473
Splitting points for all the input - but the Clng got me working!
Thanks!
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21819587
Glad you got it working!
0

Featured Post

Technology Partners: 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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

656 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