L
LisaInAz
Thank you in Advance for any Suggestions. Using Access 2000 Windows XP
I have read many articles (ie, Struggling with calculated field on form,
calculated field on form to table, etc) on storing calculated fields and why
not to.
I believe I have an exception.
My customers are supervisors and quality control staff who are accomplishing
file management reviews. A portion of the dBase is dedicated to comparing
two Dollar Amounts; one is calculated from a query. The other needs to be
determined and stored for later review.
The supervisor will use my form much like a calculator to determine
TotalDollarAmount; I have it working except I would like to store the
TotalDollarAmt back to the Main form and upon closing the form it will save
it to the table. Quality control will review the two amounts and determine
if there was an overpayment or underpayment.
I have a dedicated field on the Main Table and Main Form for the field I
need called fldActualpayment.
I have a MainTable which I would like to store fldActualpayment
I have a MainQuery for MainForm that would like to “display†from the table
fldAcutalpayment
The Third Form(not a subform) “frmCalculateActualPaymentAmt†is access from
the MainForm using a “button†that accomplishes the following calculation
Fields on form Control Name
fldfulldayrate (unbound) FullDay
fldnumberofactualdays (unbound) NumberFullDays
fldfulldaypayment (unbound) FullDayAmt
fldhalfdayrate(unbound) HalfDay
fldnumberofactualdays (unbound) NumberHalfDay
fldhalfdaypayment (unbound) HalfDayAmt
fldTotalDollarAmount = [FullDayAmt] + [HalfDayAmt] TotalDollarAmount
There is only need to store the TotalDollarAmount.
I have tried SetValue and I have read and tried to follow and other
suggestions http://allenbrowne.com/casu-14.html but I can not figure it out.
After Update property of the TotalDollarAmount Box
In the Event Procedure
Private Sub TotalDollarAmount_AfterUpdate()
Me.fldActualPayment = [FullDayAmt] + [HalfDayAmt]
End Sub
Thanks for any help
I have read many articles (ie, Struggling with calculated field on form,
calculated field on form to table, etc) on storing calculated fields and why
not to.
I believe I have an exception.
My customers are supervisors and quality control staff who are accomplishing
file management reviews. A portion of the dBase is dedicated to comparing
two Dollar Amounts; one is calculated from a query. The other needs to be
determined and stored for later review.
The supervisor will use my form much like a calculator to determine
TotalDollarAmount; I have it working except I would like to store the
TotalDollarAmt back to the Main form and upon closing the form it will save
it to the table. Quality control will review the two amounts and determine
if there was an overpayment or underpayment.
I have a dedicated field on the Main Table and Main Form for the field I
need called fldActualpayment.
I have a MainTable which I would like to store fldActualpayment
I have a MainQuery for MainForm that would like to “display†from the table
fldAcutalpayment
The Third Form(not a subform) “frmCalculateActualPaymentAmt†is access from
the MainForm using a “button†that accomplishes the following calculation
Fields on form Control Name
fldfulldayrate (unbound) FullDay
fldnumberofactualdays (unbound) NumberFullDays
fldfulldaypayment (unbound) FullDayAmt
fldhalfdayrate(unbound) HalfDay
fldnumberofactualdays (unbound) NumberHalfDay
fldhalfdaypayment (unbound) HalfDayAmt
fldTotalDollarAmount = [FullDayAmt] + [HalfDayAmt] TotalDollarAmount
There is only need to store the TotalDollarAmount.
I have tried SetValue and I have read and tried to follow and other
suggestions http://allenbrowne.com/casu-14.html but I can not figure it out.
After Update property of the TotalDollarAmount Box
In the Event Procedure
Private Sub TotalDollarAmount_AfterUpdate()
Me.fldActualPayment = [FullDayAmt] + [HalfDayAmt]
End Sub
Thanks for any help