-
SQl VBA Access 2007 -filter not working properly
Hello
Was wondering if someone could help.
I have recently upgraded to Access 2007. The code for the filter does no longer work correctly as the filter options have changed- there are more options in fact. There is a total field which shows the total. it works for 4 filters but after the the filter filter is placed it stops working. The sql query is extending and there are some brackets that need to be there to encapsulate the OR's. please can someone help
The code is connected to a form
[VBA]
If Me.filter On then
twhere = Replace(Me.Filter, "[frm_Contact]", "c.")
twhere = Replace(twhere, "(, "")
twhere = Replace(twhere, "), "")
twhere = Replace(twhere, "#", "'")
twhere = Replace(twhere, """", "'")
t_sql= t_sql & "where " & t_sql & " and c.match=0"
Else
[/VBA]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules