Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. momer123

    Type mismatch error and then continues executing

    Thanks JoeAtWork, that was great advice. I will try commenting that line of code, and find where the problem is and let you know.
  2. momer123

    Type mismatch error and then continues executing

    I am using a function to randomize the items in an array, Dim dxr() As Variant 'declared globally dim number as integer public sub proc1() ReDim dxr(number) If number > 0 Then dxr = RandomNumbers(number, 1, number) ' ERROR occurs here on this line end...
  3. momer123

    Using JOIN with where clause

    Thats great. Thanks r937
  4. momer123

    Using JOIN with where clause

    I have a table "kcionly" and I want to retrieve count of unique records for a field "ncom_1" in that table. I have another table "categories" with a field name category that just has numbers from 1 to 20. I use the below query to get the count corresponding to values, 1,2,3,.... I always want...

Part and Inventory Search

Back
Top