MySQL Forums
Forum List  »  Microsoft Access

Re: MS Access front end - MySQL back end
Posted by: Daniel Hofer
Date: May 11, 2012 01:10PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MS Access front end - MySQL back end
2033
May 11, 2012 01:10PM


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.