-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathF_User_Edit.def
37 lines (32 loc) · 2.19 KB
/
F_User_Edit.def
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
CodeBehindForm
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Compare Database
Option Explicit
Private Sub cmdAddInvoiceRates_Click()
If omStringFunctions.IsNullOrEmpty(Me.txtInvoiceRatesStartDate) Then
MsgBox "Start Date cannot be empty"
Me.txtInvoiceRatesStartDate.SetFocus
Exit Sub
End If
DoCmd.SetWarnings False
gInvoiceRateBuildUserId = Me.Id
gInvoiceRateBuildStartDate = CDate(Me.txtInvoiceRatesStartDate)
DoCmd.OpenQuery "UserProjectTypeInvoiceRates_BuildSelect"
DoCmd.SetWarnings True
Me.subInvoiceRates.Requery
End Sub
Private Sub Form_BeforeInsert(Cancel As Integer)
omFormFunctions.UpdateCreateTracking Me
End Sub
Private Sub Form_BeforeUpdate(Cancel As Integer)
omFormFunctions.UpdateModifyTracking Me
End Sub
Private Sub UserRoleId_AfterUpdate()
omControlFunctions.SetDefaultValue Me.UserRoleId
End Sub
Private Sub WorkHoursPerDay_AfterUpdate()
omControlFunctions.SetDefaultValue Me.WorkHoursPerDay
End Sub