Re: MS Access front end - MySQL back end
Refinement of previous post:
Since 3 fields can change on the lineitem to affect the EXTTOTAL, I abstracted to RecalcLI and call RecalcLi from the AfterUpdate event of each field that can be changed.
Private Sub chkUSEPRORATE_AfterUpdate()
RecalcLI
End Sub
Private Sub PRORATEP_AfterUpdate()
RecalcLI
End Sub
Private Sub UNITS_AfterUpdate()
RecalcLI
End Sub
Private Sub RecalcLI()
On Error GoTo RecalcLI_Err
If Me.ActiveControl.VALUE = Me.ActiveControl.OldValue Then
Exit Sub
End If
Refresh
Screen.MousePointer = 11
Form_frmJobs.RecalcValuesViaStoredProcedure
Me.Parent.Parent.Refresh
Screen.MousePointer = 1
RecalcLI_Err_Exit:
Exit Sub
RecalcLI_Err:
MsgBox Error$
Resume RecalcLI_Err_Exit
End Sub
Subject
Views
Written By
Posted
6333
May 07, 2012 08:05AM
3858
May 10, 2012 04:44PM
2640
May 11, 2012 10:24AM
Re: MS Access front end - MySQL back end
2288
May 11, 2012 01:10PM
3109
May 16, 2012 03:26PM
2090
May 11, 2012 01:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.