Search results

I inherited this DB and it has a function to copy all the Headers from one program to a new program and it stopped working. I am not sure if a software update has changed the way it performs or what. If anyone can help figure out what is wrong, that would be helpful. Private Sub...

Sorry, I inherited this code and trying to fix it. Private Sub Detail1_Format(Cancel As Integer, FormatCount As Integer) If Me![Expr3] = 1 Then ' Me![Part Number Label].Visible = True Me![Item Number Label].Visible = True Me![Comments Label].Visible = True Else...

Sorry, error Me![Label75].ForeColor = lngRed shold be Me![Label75].ForeColor = 255

I have a form and when the CDRL Type is Approval then I want it to show items in RED. When the CDRL Type is Non-Approval etc. then it would be black. It stopped working and I am not sure why. If anyone can point out why it doesn't turn RED it would be helpful. Private Sub...

This is great. I tried it and got this error message

This is the original code. Private Sub BDELETE_Click() On Error GoTo Err_BDELETE_Click Dim Response As String Dim Cancel As Integer Response = acDataErrContinue If MsgBox("Delete this record?", vbYesNo, "Delete Confirmation") = vbYes Then If MsgBox(" Are you SURE you want to delte this...

Yes, this function use to work and its stopped working. I tried, Me.Dirty=False and got same error message.

Private Sub BDELETE_Click() On Error GoTo Err_BDELETE_Click Dim Response As String Dim Cancel As Integer Response = acDataErrContinue If MsgBox("Delete this record?", vbYesNo, "Delete Confirmation") = vbYes Then If MsgBox(" Are you SURE you want to delte this Record?" & vbCrLf & _ "This will...

I am still getting the isn't available message

I am having the issue of my delete button saying the command or action DeleteRecord isn't available. See attached file Thank you Lesley