If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculated Field now Error
Thanks in advance.....
Simple calculated field in Form Footer, "=Sum([ControlNameonDetailSection])" has worked forever, now it shows "Error" on the calculated field. I have deleted and re-created the controls, re-created the query behind the form, and even started with a new form. Now always shows "Error". The underlying table has no Null values or anything else that might cause this error. Please help, this is very frustrating to spend hours on something so simple... This reminds me of when my Combo boxes were "vacant" yet would provide the underlying selection when mouse-clicked. This was corrected with an actual "hot-fix" from Microsoft. Is this similar? |
#2
|
|||
|
|||
Calculated Field now Error
Have a look at this page on the access web.
http://www.mvps.org/access/forms/frm0022.htm Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Bamstick" wrote in message ... Thanks in advance..... Simple calculated field in Form Footer, "=Sum([ControlNameonDetailSection])" has worked forever, now it shows "Error" on the calculated field. I have deleted and re-created the controls, re-created the query behind the form, and even started with a new form. Now always shows "Error". The underlying table has no Null values or anything else that might cause this error. Please help, this is very frustrating to spend hours on something so simple... This reminds me of when my Combo boxes were "vacant" yet would provide the underlying selection when mouse-clicked. This was corrected with an actual "hot-fix" from Microsoft. Is this similar? |
#3
|
|||
|
|||
Calculated Field now Error
Thank you, problem solved!
-- Thanks, Bamstick "Jeanette Cunningham" wrote: Have a look at this page on the access web. http://www.mvps.org/access/forms/frm0022.htm Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Bamstick" wrote in message ... Thanks in advance..... Simple calculated field in Form Footer, "=Sum([ControlNameonDetailSection])" has worked forever, now it shows "Error" on the calculated field. I have deleted and re-created the controls, re-created the query behind the form, and even started with a new form. Now always shows "Error". The underlying table has no Null values or anything else that might cause this error. Please help, this is very frustrating to spend hours on something so simple... This reminds me of when my Combo boxes were "vacant" yet would provide the underlying selection when mouse-clicked. This was corrected with an actual "hot-fix" from Microsoft. Is this similar? . |
Thread Tools | |
Display Modes | |
|
|