Forms- errors in calculation Fields when you view them in dataview

  • Thread starter blark via AccessMonster.com
  • Start date
B

blark via AccessMonster.com

I get these error# messages when ever I try to view this page in Design View.
Instead of getting the actaul totals and calculations it only happens on
this particular form. Can some one tell how to fix this prolem.


Account Name: Account Type: Current Balance: Beginning Balance: Spent:
Encumbered:
Comp Admin/LBS Purchase Lab Prep Room $2,000.00
Comp Faculty 55/45 Split Computer Services $2,000.00
Contingency Contingency error# errorr#
Curriculum Biology 145 Curriculum Areas $8,000.00 error#
Curriculum Chemistry Curriculum Areas error# error#
Curriculum Computers Curriculum Areas error# error#
Curriculum Honors Biology Curriculum Areas $7,500.00
Curriculum Math Curriculum Areas error#
Curriculum Physics Curriculum Areas error#
Curriculum STS Curriculum Areas error#
Development, Graduation Development $0.00 error#
Writing Tutor Faculty Development error#
Curriculum Biology 492 Curriculum Areas $100.00 error#
LaDuca Outreach Idea $500.00
error#
Lab Prep Room Lab Prep Room $4,000.00
zippo Maintenance
Maint Small Equipment Maintenance $2,000.00
Maint Equipment Repairs Maintenance $4,000.00
Office Supplies Office Supplies $7,000.00
Postage Postage $2,000.00
Search, Math Search $5,000.00
Seminar Series Seminar Series $2,000.00
zippo Start-ups
zippo Start-ups
 
J

John Vinson

I get these error# messages when ever I try to view this page in Design View.
Instead of getting the actaul totals and calculations it only happens on
this particular form. Can some one tell how to fix this prolem.
Click to expand...

If you're doing calculations on a Form (or a page?), that's where they
will be done: the calculated values will not be *AND SHOULD NOT BE*
stored in any Table.

It would help if you would describe this "page" - we see the results
but you have not posted any description of how you GOT these results.
Is this an Access Form? a Data Access Page? or what? What is its
Recordsource? What is the Control Source of the textbox showing the
#Error?

John W. Vinson[MVP]
 
B

blark via AccessMonster.com

Hi John,

I am viewing an Access Page in Data View when I get these error messages.
Instead getting the actual numbers that come in. It gives me #error instead
of number associated wih these total fields.

control source=[BeginningBalance]-[Accounts Subform].[Form]![TotalEncumbered]-
[Accounts Subform].[Form]![TotalSpent]

(Accounts) is the record source


Its vv
 
B

blark via AccessMonster.com

blark said:
Hi John,

I am viewing an Access Page in Data View when I get these error messages.
Instead getting the actual numbers that come in. It gives me #error instead
of number associated wih these total fields.

control source=[BeginningBalance]-[Accounts Subform].[Form]![TotalEncumbered]-
[Accounts Subform].[Form]![TotalSpent]

(Accounts) is the record source
Click to expand...
Also, for the (spent column) control source=[Accounts Subform].Form!
[TotalSpent]


Its vv
[quoted text clipped - 11 lines]
John W. Vinson[MVP]
Click to expand...
Click to expand...
 
J

John Vinson

I am viewing an Access Page in Data View when I get these error messages.
Instead getting the actual numbers that come in. It gives me #error instead
of number associated wih these total fields.
Click to expand...

Sorry, I have done very little with Data Access Pages and don't know
the syntax. Please repost the question, perhaps in a DAP newsgroup.

John W. Vinson[MVP]
 
Top