Search results

  1. H

    MsgBox Help

    Hello, I have a form that need a MsgBox to pop up when the 'BUI' is XOS and the date value 'Text118' is blank, i have used the following code. If Me.BUI.Value = "XOS" And Me.Text118.Value = "" Then MsgBox "This has yet to be sent to TA: Danny/Lee for Approval", vbOKOnly, Reminder End If i...
  2. H

    Networking Days

    Hello, I have looked around trying to find a solution to the same old problem of trying to calculate how many Working Days are between two dates in a query, I found some code that works great except when one of the dates is blank, (Brings up a debug error!). This is really annoying me, is there...
  3. H

    Advanced Conditional Formatting

    Hello, i was wondering if anyone could help me out, I have a form on my database that I require some advanced Conditional Formatting on. I require my Invoice approver Label & Invoice Approver Textbox to be faded or locked if the Request Type equals 'SSR'. I have been able to change the...
Back
Top Bottom