473,320 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Strange Calculation Results

23
I'm using Access 2003 and the file format for the DB is 2000. I have a
calculation that works fine for me but when another user logs on and runs the
same report she receives an #Error instead of the number. She is using Access 2002. I looked at the references and noticed the Microsoft Access Object Library I am using is 11.0 and the other user has 10.0. Could this be the problem. If so, how do I fix this since she doesn't have 11.0 in her list. If it's not this what other possibilities could there be?

Still trying to resolve this and coming up with other strange problems. I have opened the report with Access 2002 and fiddled with the calculations. There were 14 fields that were being added together. I only received the error when adding the 14th field. If I only added 13 fields in the calculation then I no longer received the #Error message but a number. Is there a limit to how many numbers I can add together?

Because of the above problem with the calculations I ended up creating two textboxes and summing half of the fields in each. That worked fine and I no longer had errors but numbers. But now when another user (also using 2002) runs the report she doesn't see anything. I don't know why there is always a different result depending on what users is opening the report. Can anyone shed any light on what is happening with Access. Thanks in advance for whatever help you can give.
Feb 17 '10 #1
11 1946
NeoPa
32,556 Expert Mod 16PB
I can't think of what it may be, but then I'm no expert on different versions.

It may help, when trying to think about it, to see the calculations you're talking about. I can't promise anything, but it's always harder trying to think logically in purely abstract terms.
Feb 18 '10 #2
TheSmileyCoder
2,322 Expert Mod 2GB
On your users PC, if you look at references, do you see any missing references?
Feb 18 '10 #3
AnnMV8
23
I have checked the references and other then the libraries being different (10.0 and 11) there is nothing wrong. Nothing is missing.
Feb 19 '10 #4
TheSmileyCoder
2,322 Expert Mod 2GB
Are you doing this through VBA code, or typing directly in the textbox's controlsource? Maybe the controlsource of the textbox, only supports 255 chars, and you exceed that (wild guess)

Either way, you will need to provide some more information/example data, for us to keep guessing :)
Feb 19 '10 #5
AnnMV8
23
@TheSmileyOne
This is the first time I used this site. Is there a way for all people to see each others replies? I thought if I answered a question everyone saw it???

To make it easy, in a textbox: Sum=([1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[8]+[10]+[11]+[12]+[13]+[14]) I get an #Error. If I removed [14] I get a number. I had to make two textboxes each with seven of the fields being added together.
Feb 19 '10 #6
TheSmileyCoder
2,322 Expert Mod 2GB
Well if those are indead your field names, then im guessing its not related to the length of hte controlsource string.

Have you tried doing a simple Compact and Repair? I don't really think it will help, but at this time its about the best I have left....sorry.
Feb 19 '10 #7
AnnMV8
23
@TheSmileyOne
They aren't the field names but I counted the characters in the actual string and 255 comes up at the 11th field and I can still get a good result up to and including the 13th character. Plus if it were the length none of them would work because I would always be missing the ending ). It has something to do with the versions since 2003 doesn't get the error but 2002 does. I would think there would be documentation somewhere on the Internet. Thanks for the help though I really do appreciate it.
Feb 19 '10 #8
TheSmileyCoder
2,322 Expert Mod 2GB
A workaround may be to do the calculation via VBA code, or the SQL query, but I certainly understand the frustration of something not working when its supposed to!
Feb 19 '10 #9
http://support.microsoft.com/kb/825796
Install the right library on the client's pc.
Feb 19 '10 #10
NeoPa
32,556 Expert Mod 16PB
@AnnMV8
As long as you post it in the thread they will.

Is there something you've posted that you feel has already provided this information? I don't see anything that fits the bill. Is it possible you hit a wrong button somewhere? Do you see the reply now that you posted?
Feb 20 '10 #11
AnnMV8
23
I posted a reply to you with the calculation that I couldn't find. It doesn't seem to have shown up. The one that is there is the second time I posted it. Plus, when I was trying to see all the questions and answers I couldn't. My quote mesag in reply button doesn't always work either.
Feb 22 '10 #12

Sign in to post your reply or Sign up for a free account.

Similar topics

14
by: Allcomp | last post by:
Hello, I have seen something really strange in VB6 If I do a Int ( (5 * 1.2)) , I receive the value 5, but I should receive 6? Is this a bug or something really "normal". I can see that if I...
5
by: Michael Hagstrom | last post by:
Good Day - I have written a form which collects input for a fare calculation. The form collects the following: 1) Departure or Destination Group (1,2,or 3) 2) Number of Adults 3) Number of...
24
by: David | last post by:
hello. when doing the simple following computation, the value put into the variable numMinusOne is NOT the same as what the computation is showed to be in the Watch window!! here is the code:...
31
by: Bjųrn Augestad | last post by:
Below is a program which converts a double to an integer in two different ways, giving me two different values for the int. The basic expression is 1.0 / (1.0 * 365.0) which should be 365, but one...
10
by: bear | last post by:
hi all, I have a program whose speed is so strange to me. It is maily used to calculate a output image so from four images s0,s1,s2,s3 where so=(s0-s2)^2+ (s1-s3)^2. I compile it with gcc (no...
5
by: Vedran FuraĨ | last post by:
I think that this results must be the same: In : math.atan2(-0.0,-1) Out: -3.1415926535897931 In : math.atan2(-0,-1) Out: 3.1415926535897931 In : -0 == -0.0 Out: True
11
by: Martin Joergensen | last post by:
Hi, I've encountered a really, *really*, REALLY strange error :-) I have a for-loop and after 8 runs I get strange results...... I mean: A really strange result.... I'm calculating...
3
by: bcumminsr | last post by:
Hi, Does anyone have any idea why in the immediate window in Microsoft Development Environment 2003 version 7.1 that ?240*4.1 = 983.99999999999989? I know that math.round() will correct... but...
19
by: LucasLondon | last post by:
Hi there, First of all apologies for the long post. Hope someone can offer some advice. I have about 200 columns of time series data that I need to perform a correlation analysis on in terms...
3
by: mattmao | last post by:
Okay, I was asked by a friend about the result of this limit: http://bbs.newwise.com/attdata/forumid_14/20070922_fe7f77c81050413a20fbDWYOGm7zeRj3.jpg Not n->zero but n-> + infinite I really...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.