By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Strange Calculation Results

P: 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
Share this Question
Share on Google+
11 Replies


NeoPa
Expert Mod 15k+
P: 31,494
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
Expert Mod 100+
P: 2,321
On your users PC, if you look at references, do you see any missing references?
Feb 18 '10 #3

P: 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
Expert Mod 100+
P: 2,321
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

P: 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
Expert Mod 100+
P: 2,321
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

P: 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
Expert Mod 100+
P: 2,321
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

P: 1
http://support.microsoft.com/kb/825796
Install the right library on the client's pc.
Feb 19 '10 #10

NeoPa
Expert Mod 15k+
P: 31,494
@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

P: 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

Post your reply

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