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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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.- momer123
- Post #4
- Forum: Visual Basic (Classic)
-
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...- momer123
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
-
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...
