Run Time error : 3464 ( Data Type Missmatch in criteria expression)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bamboz
    New Member
    • Sep 2008
    • 1

    #1

    Run Time error : 3464 ( Data Type Missmatch in criteria expression)

    Dears,
    I have a table named Tasks that Contains all the Information about my employee , i am making a Form to open a report based on Employee Name, Tasks done, Date.
    but i'm getting error with this code
    can u help me figure out where is my error plz

    Code:
    Private Sub Command20_Click()
    Dim sFilter As String
    sFilter = ""
    
    If Me.Name.ListIndex <> -1 Then
        If sFilter = "" Then
            sFilter = "[Assigned To]= " & Me.Name & ""
            Else
            sFilter = sFilter & " And [Assigned To]=" & Me.Name & ""
        End If
    End If
    
    If Me.Task.ListIndex <> -1 Then
        If sFilter = "" Then
            sFilter = "[Title]= '" & Me.Task & "'"
            Else
            sFilter = sFilter & " And [Title]='" & Me.Task & "'"
        End If
    End If
    
     If Format(Me.Dates, "MM/DD/YYYY") <> -1 Then
        If sFilter = "" Then
            sFilter = "[Date]= '" & Format(Me.Dates, "MM/DD/YYYY") & "'"
            Else
            sFilter = sFilter & " And [Date]='" & Format(Me.Dates, "MM/DD/YYYY") & "'"
        End If
    End If
    
    DoCmd.OpenReport "Agent Total Hour", acViewPreview, , sFilter
    
    End Sub

    NB: if i need to set a range so i can choose between 2 dates what would i do plz

    Thanks in advance.
    Elie Nakhle.
    Last edited by Stewart Ross; Sep 29 '08, 08:31 AM. Reason: Please use the CODE TAGS provided
  • Stewart Ross
    Recognized Expert Moderator Specialist
    • Feb 2008
    • 2545

    #2
    Hi. Rather than have us guess what your error is and where it is occurring, please tell us the line number (referred to the code-tagged line numbers now shown in post 1 above) and the exact nature of the error that occurs.

    I would also ask you not to use phone-text abbreviations in your posts, as many readers will not be able to work out what these mean.

    Thank you.

    -Stewart

    Comment

    Working...