Search results

  1. J

    Build an "or" clause in VBA and use as criteria in a query

    Bump this to the top. I am stumped.
  2. J

    Build an "or" clause in VBA and use as criteria in a query

    Ok, new approach. This does not return any rows. ------------- DoCmd.OpenReport "rptlanerebates", acViewPreview, , "((Customers.MonthRyanPd) Between #" & [Forms]![fmnubldrrebates].[txtStartDate] & "# And #" & [Forms]![fmnubldrrebates].[txtEndDate] & "# AND ((Customers.builder)='J. A. Myers...
  3. J

    Build an "or" clause in VBA and use as criteria in a query

    Once again it works only if I type In ('J. A. Myers Homes','Capano Homes') in the criteria of the query. For some reason the code generated does't work. This is what I assume the code is creating - In ("'J. A. Myers Homes','Capano Homes'") with that extra " because it is a string field. How...
  4. J

    Build an "or" clause in VBA and use as criteria in a query

    No dice. I changed the VBA as you instructed and here is the new SQL. Did i do it right? SELECT Customers.MonthRyanPd, Customers.Appt_Date, Format([Lot_#],"> ") AS [LOT#], Customers.Subdivision, Customers.[CUST#1_LAST], IIf(Customers!Contract_Amount Is Null,0,Customers!Contract_Amount) AS...
  5. J

    Build an "or" clause in VBA and use as criteria in a query

    I have the following code that puts a string together and throws it into a hidden textbox (txtreportcriteria) on a form (fmnubldrrebates) for me and it looks right but I don't get any records back from the query when using it. There are records to return I tried just typing in "Kent Bridell...
  6. J

    "search key not found" error

    Install the Jet 4.0 service pack 6 to solve this error message. It can be found on Microsoft's website. If your dbase is on a server install in on your server as well. ~ Joe
Back
Top Bottom