Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub cmdEditAll_Click()
- strFormName = Me.Name
- Call ToggleEdit
- end sub
- Option Compare Database
- Public strFormName As String
- Sub ToggleEdit()
- Dim ctrlControl As Control
- On Error GoTo err:
- For Each ctrlControl In Forms(strFormName).Controls
- Debug.Print ctrlControl.Name
- If booEnabled = False Then
- Forms!frmfullcourseinfo.cmdEditAll.Caption = "Edit"
- Forms!frmfullcourseinfo.lblMode.Caption = "[Read Only]"
- If ctrlControl.ControlType = acTabCtl Or ctrlControl.Name = "Command9" Or ctrlControl.Name = "cmdeditall" Then
- Else
- ctrlControl.Enabled = False
- ctrlControl.AllowEdits = False
- End If
- Else
- Forms!frmfullcourseinfo.cmdEditAll.Caption = "Stop Edit"
- Forms!frmfullcourseinfo.lblMode.Caption = "[Edit Mode]"
- If ctrlControl.ControlType = acTabCtl Or ctrlControl.Name = "Command9" Or ctrlControl.Name = "cmdeditall" Then
- Else
- ctrlControl.Enabled = True
- ctrlControl.AllowEdits = True
- End If
- End If
- Continue:
- Next
- booEnabled = Not (booEnabled)
- Exit Sub
- err:
- Debug.Print err.Description
- Resume Continue
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement