Solved

Overflow Error on Calculation

Posted on 2008-06-15
560 Views
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
Question by:SeanNij
• 7
• 5
• 4
• +1

LVL 46

Expert Comment

ID: 21791146
Hi SeanNij,

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

Gary
0

LVL 1

Author Comment

ID: 21791184
w_calc is long
shankdiameter is single
overlength is single
0

LVL 46

Accepted Solution

ID: 21791211
try w_calc = CLNG(3.14159265 * (Me.ShankDiameter / 10) ^ 2 * Me.OverallLength * 7.8 / 10 * 4 * 1000)
0

LVL 1

Author Comment

ID: 21791444
nope - same error
0

LVL 17

Assisted Solution

Natchiket earned 100 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

peter57r earned 100 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

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

LVL 77

Expert Comment

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

ID: 21792324
RunTime Error '6'
Overflow i use immediate window
0

LVL 77

Expert Comment

ID: 21792381
How peculiar...see attached

You are definitely using Access 2003?

Doc6.doc
0

LVL 46

Expert Comment

ID: 21792438
Check that you don't have any missing references
0

LVL 1

Author Comment

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

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

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

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

LVL 1

Author Closing Comment

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

LVL 46

Expert Comment

ID: 21819587
0

Featured Post

Question has a verified solution.

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

Suggested Solutions

In Debugging â€“ Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can usâ€¦
Overview: This article:       (a) explains one principle method to cross-reference invoice items in QuickbooksÂ®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a Mâ€¦
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micrâ€¦
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final pâ€¦