Search results

  1. R

    'Data type mismatch in criteria expression' - when filtering query

    A very complex query, involves four tables (about 2/3 of that data in the enterprise system that it is) and 4 very complex complex criteria. one of which is so complex I had to write a function for it) THAT works. But if the user right-clicks on the form (or me on the query) and tries to...
  2. R

    Dmin for nulls?

    I have a table of Transactions "tblTransactions" in which more than one row will have the same PO number. Each row has a date field called "POSubDate" I need to know if *any* row has a null in that field. I tried: If IsNull(DMin("POSubDate", "tblTransactions", "POno = " & Chr(34) & Me.PONo &...
  3. R

    Q: Exposing a function within a DLL to the Eval() function

    Still working on this problem from another thread. I have a third party COM object DLL called ImageMagick, I’ve registered the DLL with RegSvr, and I’ve been using it by declaring an object variable and setting a reference within an individual sub. It has a “convert” command that saves a file...
  4. R

    Q:how to call a method with a variable number of parameters?

    Given that this works: MyObject.MyMethod ("foo","bar") this would work: str1 = "foo" str2 = "bar" MyObject.MyMethod (str1,str2) but this will not: str1= Chr(34) & "foo" & Chr(34) & "," & Chr(34) & "bar" & Chr(34) MyObject.MyMethod (str1) even though str1 = "foo","bar" it is still one...
Back
Top Bottom