Search results

  1. A

    Secondary Array is out of range

    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...
  2. A

    Interested in RecordSource functionality

    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
  3. A

    Accessing subform data

    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...
  4. A

    Question about Combo Boxes and WHERE clauses

    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...
Top Bottom