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.
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.
On your users PC, if you look at references, do you see any missing references?
I have checked the references and other then the libraries being different (10.0 and 11) there is nothing wrong. Nothing is missing.
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 :)
@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.
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.
@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.
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!
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?
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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:...
|
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...
|
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...
|
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
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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...
| |