Search results

  1. T

    using For Each statement

    I have a multi-select listbox (lstValues) and I am using the ItemsSelected property to return the values selected in the list in a message box. The items selected in the list are: Apples, Oranges, Grapes. My message box displays it as: or Apples or Oranges or Grapes I want my message box to...
  2. T

    simple but complex expression

    thanks anyway .. but I figured it out. The expression works now: =DCount("[id]","tblGetPendingPercentage","[1stDateRecvd] = [bicompleted] AND ([company] = reports!rptContractorsIncomplete_byVendor_summary![company])")
  3. T

    simple but complex expression

    I am trying to enter an expression that simply counts the amount of records in myTable where the value in the company field is equal to the company name on the report and where the value of [1stDate] in myTable is equal to [bicompleted] in myTable. Here is my expression that produces an error...
  4. T

    Check boxes

    thank you. I apologize for getting back to this so late.
  5. T

    Check boxes

    I have 5 check boxes. I want to be able to display which checkbox is checked. How can I do that in VBA? For example: If checkbox1 and checkbox4 is checked, I want a message box to display the names of "checkbox1 and checkbox4".
Back
Top Bottom