D
Downie
Ok, I've been at this for a few hours now.
I can't figure out why I can lock certain rows and columns leaving some
cells updatable with the below code:
Why can't change the color of that same cell that is unlocked and
updatable.
See "Me.active_jobs_msglog_crtdt.ForeColor = 69500"
Private Sub Form_Current()
If Me.updatable_item.Value = True Then
Me.updatable_item.Locked = True
Me.Job_Name.Locked = True
Me.active_jobs_msglog_crtdt.Locked = False
Me.active_jobs_msglog_crtdt.ForeColor = 69500
Me.completed_jobs_msglog_crtdt.Locked = False
Me.actual_process_time.Locked = True
Me.Estimated_Process_Time.Locked = True
Else
Me.updatable_item.Locked = True
Me.Job_Name.Locked = True
Me.active_jobs_msglog_crtdt.Locked = True
Me.completed_jobs_msglog_crtdt.Locked = True
Me.actual_process_time.Locked = True
Me.Estimated_Process_Time.Locked = True
End If
End Sub
I can't figure out why I can lock certain rows and columns leaving some
cells updatable with the below code:
Why can't change the color of that same cell that is unlocked and
updatable.
See "Me.active_jobs_msglog_crtdt.ForeColor = 69500"
Private Sub Form_Current()
If Me.updatable_item.Value = True Then
Me.updatable_item.Locked = True
Me.Job_Name.Locked = True
Me.active_jobs_msglog_crtdt.Locked = False
Me.active_jobs_msglog_crtdt.ForeColor = 69500
Me.completed_jobs_msglog_crtdt.Locked = False
Me.actual_process_time.Locked = True
Me.Estimated_Process_Time.Locked = True
Else
Me.updatable_item.Locked = True
Me.Job_Name.Locked = True
Me.active_jobs_msglog_crtdt.Locked = True
Me.completed_jobs_msglog_crtdt.Locked = True
Me.actual_process_time.Locked = True
Me.Estimated_Process_Time.Locked = True
End If
End Sub