Search results

Hi all, I was curious if someone could tell me why my arr2 is out of range, I can't seem to figure out what is going on with it. Dim arr2() As String ReDim arr2(0) Dim j As Integer For i = LBound(arr) To UBound(arr) If arr(i) = arr(i + j) Then For j = 0 To 200...

I apologize for any and all miscommunications I may have caused, it wasn't my intent. I was able to get something functional by looping through my array and making a giant WHERE ... AND ... AND ... AND ... etc statement. I appreciate the input from everyone.

I'm going to give the comma delimited string a try, I did try it the other way but it didn't work. I think that if we design the string to properly function like the WHERE clause does and then add the two strings together it should work.

Hello, If we were to take an array loaded with data, is it possible to filter the WHERE clause in a record source with this array? ie WHERE [Tools].[ToolID]=" & arrTooling(i) & "" or something similar

I went ahead and used the recordset to iterate through my columns until I found the correct column (they're static so they shouldn't change ever), and then iterated through the rows to put the data into a string. It's kind of a complex program that I'm creating, which I'm sure there are more...

Thank you! So, when it's in a recordset, how would I go about selecting certain data. Please correct me if I'm wrong, but doesn't recordset take the entire data set into memory? Would I use something like dim stringname as string stringname = recordset![whatever I want to take from the...

Hello All, I currently have a subform that is being filtered by a combo box. I was curious if it was possible to access the subform data VIA VBA. I've tried searching this for a few weeks and I really haven't been able to find anything; any source I did find that did "solve" a similar issue...

Many thanks! This worked wonderfully. I had a feeling that it was something specific that I just hadn't picked up since I'm self taught when it comes to access VBA.

Hello, I'm currently creating a database to categorize a bunch of stuff in my house, and now I'm looking into making a rudimentary search function through the various tables. I've pinpointed my error, but I'm really quite unsure how to fix this as I'm a novice with access VBA. I have two...