Search results

I just opened up the last version on this thread and it did it again. All that I am doing is clicking the arrow buttons. I'm using Office 365. Could it be a a software version difference between you and I?

@theDBguy Thanks for helping me on this problem. This working great except for when I move the value of the filter control textbox beyond 4 or -4 and then manually move it back to 0. When the textbox appears to equal 0 it is actually equal to 3.46944695195361E-18 or -3.46944695195361E-18. I...

@theDBguy Could I use an if statement to specify the filter, such as: If Me.lstBaseModel.ItemsSelected.Count = 0 Then Me.Filter= 'Everything but strWhere Else if Me.lstBaseModel.ItemsSelected.Count > 0 Then Me.Fiter= 'Everything including strWhere End if Me.FilterOn=True Would...

I am trying to filter a split form using a multi-value list box. It is necessary to have the ability to include multiple values in the "Base Model" filter, but I want to see everything when there is no selection made. I have used the following code: Dim strWhere As String Dim ctl As...

That was it. It think I have a better understanding of what you were doing too. I didn't catch that you added the procedure to the buttons. Thanks

Yes, my code matches what you put. Is there something other than the AddFilter procedure that is being done to make the filters work?

I hate to continue bothering you, but I cant seem to get the other filters to work. I just extended your select case and it they don't work. Is there something that I am missing. I really want to understand how this done so that I can apply it my real database. I'm attaching the changes that...

By the way, what did you do to resolve the reset issue?

It works awesome now. I have been trying to figure this out for days and you did it in minutes. Thanks a bunch.

This looks great. The only problem that I see is that when I hit the reset default button it doesn't requery, and when I hit enter is the textbox value goes to 1. Any ideas? You are the best. I cannot thank you enough.

@theDBguy and @strive4peace here is a dummy version of what I am using. The form in question is "O". Some features of the form will not work because I have deleted them. Please let me know if you have questions. I really appreciate your help.

I think another problem is that the fields that I want to filter on are calculated in a query. They are not part of any table. Could this be causing the issue?

@strive4peace and @theDBguy I tried the code that was posted previously and it didn't work. I think it has something to do with the code being directed toward a string and I'm trying to filter numbers. Below are the answers to the questions that were posted earlier. 1. what are the names of...

@strive4peace will this work with numeric inputs as well? Also I have approximately three of these filter criteria textboxes on each of my forms. Will this method allow for filters to work in conjunction with each other? Thank you so much for the help.

I can't really share because it is proprietary information. The problem is that I have my filter criteria textboxes linked to the query as criteria. That works fine when all the numbers are positive but the users in my company want the information presented in a way that would have negative...

Creating an access database for work. Users will use a split form with only the datasheet visible to review and manipulate numeric data. On the form I have built in quick filters that consist of of textboxes in which the values are either raised or lowered with arrow buttons that have on-click...

No, I’m currently linking the textboxes from the form directly to the query criteria. However, I just recently discovered that I need to filter positives, negatives, and have no filter when the value is zero. I’ve never used the filter property, so I’m not quite sure how to code it for this...

Creating an access database for work. Users will use a split form with only the datasheet visible to review and manipulate numeric data. On the form I have built in quick filters that consist of of textboxes in which the values are either raised or lowered with arrow buttons that have on-click...