Search results

  1. L

    Filter report by fields with Null value

    I have ElseIf Me.chkIncompleted = True And Me.cbrEngineer & "" <> "" Then strFilter = "[Total Hours Worked] Is Null And " & _ "[Engineer 1] = '" & Me!cbrEngineer & "' OR " & _ "[Total Hours Worked] Is Null" And " & _...
  2. L

    Filter report by fields with Null value

    Ive tried that... it doesnt work
  3. L

    Filter report by fields with Null value

    why u torture me like this? its nearly christmas ;)
  4. L

    Filter report by fields with Null value

    I give up... i really dont know
  5. L

    Filter report by fields with Null value

    i have tried everything i can think of, please tell me :)
  6. L

    Filter report by fields with Null value

    No. i cant see what the problem is... sorry
  7. L

    Filter report by fields with Null value

    I didnt understand what you meant before and then had to do something else, and the rest of them work so why change it?
  8. L

    Filter report by fields with Null value

    I cant see where its gone wrong... and Normalized?
  9. L

    Filter report by fields with Null value

    Sorry to botheryou ain but do you know what the problem with this code is? ElseIf Me.chkIncompleted = True And Me.cbrEngineer & "" <> "" Then strFilter = "[Total Hours Worked] Is Null" And " & _ "[Engineer 1] = '" & Me!cbrEngineer & "'Or " & _...
  10. L

    Filter report by fields with Null value

    Wow i cant believe i didnt see that haha, thanks again mate
  11. L

    Filter report by fields with Null value

    Huh... strange they looked exactly the same but then i copied ures in and now it works... Thanks :)
  12. L

    Filter report by fields with Null value

    it says Syntax error (missing operator) in query expression '[Total Hours Worked] = Is Null'.
  13. L

    Filter report by fields with Null value

    No idea im afraid
  14. L

    Filter report by fields with Null value

    i get Run-time error '3075' with that
  15. L

    Filter report by fields with Null value

    This is my code so far ElseIf Me.chkIncompleted = True Then strFilter = "[Total Hours Worked] = IsNull" DoCmd.Close DoCmd.OpenReport "VisitSheetTableReport", acViewReport, , strFilter What i want to achieve is it to return any records that have "Total Hours...
  16. L

    Textbox only allowing input when another textbox is not Null

    i cant upload it, its too big
  17. L

    Textbox only allowing input when another textbox is not Null

    Im getting this: The expression On Load you entered as the even property setting produced the following error: Procedure decleration does not match the description of event of procedure hacving the same name. *The expression may not result in the name od a macro, the name of a user defined...
  18. L

    Textbox only allowing input when another textbox is not Null

    Im confused :S what is the code?
  19. L

    Textbox only allowing input when another textbox is not Null

    Private Sub Engineer_2_AfterUpdate() If Len(Me.Engineer 1 & vbNullString) = 0 Then Cancel = True MsgBox "Engineer 1 must be filled in ..." End If End Sub the box is called Engineer 1 not Engineer1 do i need a _?
  20. L

    Textbox only allowing input when another textbox is not Null

    This gives me a syntax errror
Back
Top Bottom