For the following code I'm getting a runtime 2467 expression not available error only on my Windows 7 machines.
Me.Browse.Form.Filter = strWhere
I am completely lost as to why.
For the following code I'm getting a runtime 2467 expression not available error only on my Windows 7 machines.
Me.Browse.Form.Filter = strWhere
I am completely lost as to why.
I'm gonna be honest. I'm not familiar with the "Browse" Object and, because Google it horrible for "technical language" searches, haven't been able to find anything on it...
Can you give me more info on what it's for?
[Solution] "Browse" was just a FORM name. The actual code looked like this:
==================
If Title
If Nz(Me.Program) <> "" Then
' Add it to the predicate - match on leading characters
strWhere = strWhere & " AND " & "MainDB.Programpre Like '*" & Me.Program & "*'"
End If
' If Case #
If Nz(Me.[CaseNumber]) <> "" Then
' Add it to the predicate - match on leading characters
strWhere = strWhere & " AND " & "MainDB.[Case #] Like '*" & Me.[CaseNumber] & "*'"
End If
==========
So I slowly back tracked into why it was giving this error and when I tried to open the subform directly it gave me the OLD path of a split back-end database.
I have no idea where this information was stored - but if anyone does know that would be useful.
In the end what I did was go back to an earlier copy of my DB - Split it again in the right locations and then distributed out the Applications Dbs.
Ah, if Browse is the name of a Form, then you should use Forms!Browse.Form.Filter (or just Me.Form.Filter if you're executing code from within the Form) to reference it instead of Me.Browse.Form.Filter. It's (marginally) faster and there's less ambiguity in the code.
As for your program, that's probably the easiest way to deal with it if you're not sure what Tables were linked correctly and what weren't. The Linked Table Manager that comes with Access is pretty clunky (It's the second item on the "External Data" Ribbon).