 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / October 2005Filters more than 255 characters
I have filters I have to apply to an access form that are more than 255 characters: Division IN ('Administration','Recreation',.... etc. to beyone 255 characters. When I watch the ServerFilter or Filter properties in my watch list they are always cut off at 255 characters. Is there any way to use the longer filters? Also should I be using the Filter or ServerFilter property? Thanks. Ryan Hmmm it does appear the Filters are holding over 255 characters now, it must have been one of my string variables cutting them off. However, the filters still seem not to be working. On the form I have Allow Filters = True, but setting Me.Filter and then doing a Me.Requery does not seem to apply the filter. Do I have to use the ServerFilter property instead? >I have filters I have to apply to an access form that are more than 255 >characters: [quoted text clipped - 6 lines] > > Ryan If you're doing it programmatically, you've probably missed the "Me.FilterOn = True" part. Just add that right after Me.Filter, and it should be fine. I believe whenever you execute that, it automatically requeries, but I don't have Access handy on this computer, so you'll have to test it yourself and make sure. Rob > Hmmm it does appear the Filters are holding over 255 characters now, it > must have been one of my string variables cutting them off. However, the [quoted text clipped - 12 lines] >> >> Ryan so in which ORDER should you do this? what is the best way to apply a filter to make sure that it doesnt do more requerying than it needs. I mean.. for starters IF Me.Filter <> "ROWID = 312" Then Me.Filter = "ROWID = 312" IF Me.FilterOn <> True then Me.filterOn = True that would be more efficient. RIGHT? -aaron Robert, You're right, I just forgot to set the Me.FilterOn = True. I went through my code and added that after every Me.Filter = myVar statement and everything works great now. Thanks, Ryan > If you're doing it programmatically, you've probably missed the > "Me.FilterOn = True" part. Just add that right after Me.Filter, and it [quoted text clipped - 20 lines] >>> >>> Ryan |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.