Serious Database Error

  • Thread starter kryszystof via AccessMonster.com
  • Start date
K

kryszystof via AccessMonster.com

Hello, good afternoon, and please help!

I have a form where i have several fields, and certain fields are used to
create a calculated field, meaning one with no control, just a formula.
those work fine. i want another calculated field where it takes one
controled fielddivided by the calculated field. seems simple, yet database
*crashes* saying If i want to send error report to Microsoft. everytime i
open it, that happens. Then i took the new field out of form, and everything
Ok. What seems to be problem, I have done this before, and had no problem.
could it have to do with null values, possibly? TIA, correction much thanks
in advance.
 
K

Klatuu

I think what may be happening is that when the form opens, the calculated
field has not yet been calculated. It may be returning a Null or a 0.
Anything divided by Null returns Null and a divide by 0 raises error 11.
This, of course is not as bad as what you are experiencing.
I have never experienced this, but I have also never based a calculation on
a calculated control. It could be the order in which the calculations are
done.
In any case, I am only speculating and hopefully giving you some ideas to
consider.
A work around may be to do the calculation at a different time, like in the
current event and/or the after update event of one of the controls.
 
D

Dodo

I have a form where i have several fields, and certain fields are used
to create a calculated field, meaning one with no control, just a
formula. those work fine. i want another calculated field where it
takes one controled fielddivided by the calculated field.
Click to expand...

Why not do the same calculation in the other field with the additions
needed?
 
K

kryszystof via AccessMonster.com

K

kryszystof via AccessMonster.com

To add to this thread:

hello, I have taken care of the problem with calculations, and things work
fine. Now I have a report, that have in a horizontal format, with field
names in the page header, and fields in the detail. well, i wanted to shrink
the report, and it is not happening. I have turned on CanShrink, and yet it
still has a space where there are null values. I have the from setup like
this:



Id | name | field | field | field | field | field | field
| field | field | field | field
etc..
have a total of eight rows, because there is more than one instance per ID.

Someone said my report not set up correct?

TIA
~K



Thanks,

I will have to see if that will work. the reason i cannot do the
calculations in same field because they are seperate values the user needs to
see.[quoted text clipped - 8 lines]
http://support.microsoft.com/default.aspx?scid=kb;en-us;95911
Click to expand...
Click to expand...
 
D

Dodo

To add to this thread:

hello, I have taken care of the problem with calculations, and things
work fine. Now I have a report, that have in a horizontal format,
with field names in the page header, and fields in the detail. well,
i wanted to shrink the report, and it is not happening. I have turned
on CanShrink, and yet it still has a space where there are null
values. I have the from setup like this:

Id | name | field | field | field | field | field | field
| field | field | field |
field etc..
have a total of eight rows, because there is more than one instance
per ID.
Click to expand...

Can shrink vertically only, so all fields on a row have to be empty.

Have you set can shrink both for the section and for the fields?
 
K

kryszystof via AccessMonster.com

Dodo,

Yes, I do want it to shrink vertically, so ok there. but no, I have not
changed canshrink on fields
I will try that
Thanks!
To add to this thread:
Click to expand...
[quoted text clipped - 10 lines]
have a total of eight rows, because there is more than one instance
per ID.
Click to expand...

Can shrink vertically only, so all fields on a row have to be empty.

Have you set can shrink both for the section and for the fields?
Click to expand...
 
Top