Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. Private Sub cmdEditAll_Click()
  2. strFormName = Me.Name
  3.  
  4. Call ToggleEdit
  5.  
  6. end sub
  7.  
  8. Option Compare Database
  9. Public strFormName As String
  10. Sub ToggleEdit()
  11. Dim ctrlControl As Control
  12.  
  13.  
  14. On Error GoTo err:
  15. For Each ctrlControl In Forms(strFormName).Controls
  16. Debug.Print ctrlControl.Name
  17. If booEnabled = False Then
  18. Forms!frmfullcourseinfo.cmdEditAll.Caption = "Edit"
  19. Forms!frmfullcourseinfo.lblMode.Caption = "[Read Only]"
  20. If ctrlControl.ControlType = acTabCtl Or ctrlControl.Name = "Command9" Or ctrlControl.Name = "cmdeditall" Then
  21. Else
  22. ctrlControl.Enabled = False
  23. ctrlControl.AllowEdits = False
  24. End If
  25.  
  26. Else
  27. Forms!frmfullcourseinfo.cmdEditAll.Caption = "Stop Edit"
  28. Forms!frmfullcourseinfo.lblMode.Caption = "[Edit Mode]"
  29. If ctrlControl.ControlType = acTabCtl Or ctrlControl.Name = "Command9" Or ctrlControl.Name = "cmdeditall" Then
  30. Else
  31. ctrlControl.Enabled = True
  32. ctrlControl.AllowEdits = True
  33. End If
  34. End If
  35. Continue:
  36. Next
  37.  
  38. booEnabled = Not (booEnabled)
  39. Exit Sub
  40. err:
  41. Debug.Print err.Description
  42. Resume Continue
  43. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement