Re: Help SQL filter

Tech-Archive recommends: Speed Up your PC by fixing your registry


"dib" <dNOSPAMibs@xxxxxxxxxxx> wrote in message
news:eOusrLrqFHA.1252@xxxxxxxxxxxxxxxxxxxxxxx

> I have this and it is returning an error
> Runtime Error '3001' Arguments are of the wrong type, are out of
> acceptable range or are in conflict with one another.
>
> strBID is a String.
>
>
>
> rsTransH.Find "custid ='" & !CustId & "' And batchid ='" &
> strBId & "'"

Is this DAO or ADO? Because ADO does not support multiple criteria (i.e., no
ANDs) in the Find method. If this is DAO, build a string with your criteria
and examine it in the debug window before you actually try to call Find. If
you don't spot a problem, post that string here.


.

Relevant Pages

  • Re: Help SQL filter
    ... Jeff, is there a way around this, I am using ADO 2.8. ... Because ADO does not support multiple criteria (i.e., ... If this is DAO, build a string with your ...
    (microsoft.public.vb.general.discussion)
  • Re: Cbool problem
    ... >I built up a string in code and now I wish to evaluate it ... > using Cbool but I get a runtime error. ... For compiled programming languages it's not that easy. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Automate import .csv into table
    ... >What does that string look like? ... >> i followed the basic instructions in the database help ... >> when i run the code i come up with a runtime error ... >> is not an EXCEL ...
    (microsoft.public.access.externaldata)
  • RE: Check function parameters for null Values
    ... expected (normally generates Runtime Error 94). ... > The following example in mytest1 worksbut requires hard coding the controls ... I really need to specify parameters like in the second example ... > Function mytest2(a As String, ...
    (microsoft.public.access.modulesdaovba)
  • RE: Programming Loop with SQL Update Query
    ... John C Brainard wrote: ... >the code field is declared as string. ... >Runtime Error '3075' ...
    (microsoft.public.access.modulesdaovba)