Search results

  1. C

    Filtering Currency

    Thanks Rich, but I just figured it out. I had the string result in quotes, so it naturally thought it was text!
  2. C

    Filtering Currency

    I may have over simplified my problem. This is only a piece of my code. This is a form filter that filters about 15 different fields. Here is the complete code with the problem area in red. Private Sub cmdApplyFilter_Click() Dim strName As String Dim strProjectUseFunction As String...
  3. C

    Filtering Currency

    I am trying to get a field that is set to currency to filter, i.e. I want to get all records where my amount field is > $1,000,000. I am doing this through code. Here is part of what I have as my code: strCompletionAmount = "[Final Contract]> '" & Me.txtAmount.Value & "'" strFilter =...
  4. C

    Filtering Currency

    Can someone please tell me what the secret is to filtering currency on a report filter? Keep getting data type mismatch error. Thanks
  5. C

    Filtering Report Using Dialog Box

    Thanks for your help. I am not very good at coding. How do I tie this into my code for my text box (txtName) and my private sub for the apply filter button?
  6. C

    Filtering Report Using Dialog Box

    I have set up a form to filter my report with. I want to be able to filter my name field using a text box and typing in a comma separated string that would use the "contains" wildcard for each item in the string. Is it possible to filter by multiple "contains" using a text box? If so, please...
Back
Top Bottom