On Error GoTo Err_Delete_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Exit_Delete_Click:
Exit Sub
Err_Delete_Click:
MsgBox Err.Description
Resume Exit_Delete_Click
End Sub
Function Close1()
DoCmd.Close
End Function
Function IsLoaded(ByVal strFormName As String) As Integer
' Returns True if the specified form is loaded.
Const conDesignView = 0
Const conObjStateClosed = 0
IsLoaded = False
If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> conObjStateClosed Then
If Forms(strFormName).CurrentView <> conDesignView Then
IsLoaded = True
End If
End If
End Function
Shomoy's Blog
This is the my First Blog............
Tuesday, November 18, 2014
Create A Form of Worker Area Ware
Private Sub AreaCode_Change()
If AreaCode.Value = "MA" Then
Label6.Caption = "Manager"
End If
If AreaCode.Value = "SE" Then
Label6.Caption = "Second Officer "
End If
If AreaCode.Value = "CM" Then
Label6.Caption = "Center Manager"
End If
Creat A Input Form.
Private Sub Result_Click()
If Me.Sing.Value = "-" Then
Me.Results.Value = Me.InputN - Me.Inputs
Me.Results.Visible = True
End If
Created A LogOn Form.
Private Sub Form_Open(Cancel As Integer)
Form.DataEntry = True
End Sub
--------------------------------------------------------------------------------------------------------------
Private Sub Form_Timer()
Me.Label8.Caption = Time()
Me.Label8.Width = 1000
Me.Label8.Height = 1500
Monday, November 17, 2014
Create A Certificat Form
Private Sub AreaCod_Enter()
Me.AreaCod.Value = Me.AreaCode.Value
End Sub
Private Sub BranchNameof_Enter()
BranchNameof.Value = BranchName
If Combo18 = "cÖv_wgK" Then
examc.Value = 1
End If
If Combo18 = "gva¨wgK" Then
examc.Value = 3
End If
If Combo18 = "D”P gva¨wgK" Then
examc.Value = 4
End If
Me.AreaCod.Value = Me.AreaCode.Value
End Sub
Private Sub BranchNameof_Enter()
BranchNameof.Value = BranchName
If Combo18 = "cÖv_wgK" Then
examc.Value = 1
End If
If Combo18 = "gva¨wgK" Then
examc.Value = 3
End If
If Combo18 = "D”P gva¨wgK" Then
examc.Value = 4
End If
Create A Preview Report Form.
Private Sub EntryDate_LostFocus()
Me.AreaCode.Requery
End Sub
---------------------------------------------------------------------------------------------------------------
Private Sub Form_Load()
On Error GoTo err_Load
CNG.Value = False
Form.InsideWidth = 4590
Form.InsideHeight = 3100
'ÕMe.Preview.ControlTipText = Time()
err_Load:
End Sub
---------------------------------------------------------------------------------------------------------------
Private Sub Form_Timer()
Me.TimerInterval = 2500
Me.Detail.BackColor = Rnd * 12632256
End Sub
Made A Salary Change to Leave Form.
Private Sub AreaCode_Enter()
Label48.BorderColor = 4227072
Label48.BorderStyle = 0
Label48.SpecialEffect = 0
Label48.BackColor = 12632256
Label48.BorderWidth = 0
Label48.FontName = "SutonnyMJ"
Label48.FontSize = 13
If AppDate.Value <> 0 Then
Label48.Caption = "cieZ©x‡Z wZwb " & AppDate + 1097 & " Bs Zvwi‡L Av‡e`b Ki‡Z cvi‡eb|"
Me.sflfBranchCode.Value = (Me.BranchCode)
Me.AmountofSalary.Value = (Me.Amount.Value)
Me.MatuDate.Value = (Me.AppDate.Value + 1097)
End If
If IsNull([AppDate]) Then
Label48.Caption = "*** Av‡e`‡bi ZvwiL Gw›Uª †`Iqv nq bvB|"
End If
Subscribe to:
Comments (Atom)