Recent content by mukraker

Thanks for the tip. I am going to try to get it working in one of my forms, then change all of them once I am comfortable with it . I think it will also help with performance as the size of the tables grow.

This took some thinking through. Eventually changed strWhere = Left(strWhere, Len(strWhere) - 4) to strWhere = "(" & Left(strWhere, Len(strWhere) - 4) & ")" This worked like a charm. It also fixed several filtered reports that have been behaving incorrectly for months. Thank you so much...

Hello, I have created a report to filter by [Employee Name] and by [DATE] When I run the filtered report, the report returns only the Employee Names I have selected from the list box (which is as it is supposed to do) but it returns the Employee Names for all dates in the database instead of...

Thanks Paul. I didn't consider that. I will try to see if I can add quotes to the zip codes later. In the meantime I can at least use what I have so far.

lagbolt and Paul, you guys are amazing!! I added the Join(Split()) ... Then instead of adding a quote to each zip I went back to the original table and changed the zipcode from a text field to a number. Now it works exactly as I want it to. Thank you very much. Thanks to you guys I just...

Sorry Paul. the Text Box txtZips has a list of zip codes for instance when I type in 37115 and 10 miles the text box returns: 37072,37075,37076,37080,37115,37122,37138,37152,37189,37201,37203,37204,37206,37207,37208,37209,37210,37212,37213,37214,37216,37217,37218,37219,37228 Or if I type in...

Thanks for the quick reply Paul. I added the line strWhere = "[ZIP_CODE] IN(" & Me.txZips & ")" and commented out the other two as you can see below. Not when I run the code nothing happens. When I run the script however if the rptCustomers is already open it will close it. So I seem to...

I kind of wondered if I was attacking this completely wrong. It is indeed a text box. I have a form that someone else made that returns a list of zip codes within the mileage radius that I enter. I created a report from all of our customers and I am looking for some way to auto select all the...

I have a query that returns a list of zip codes in a text box in a form. Now I would like to use the list of zip codes in the text box to filter a report to generate a list of all customers within the corresponding zip codes. When I run the script I get ""438 - Object doesn't support this...

Success! Thanks Paul. You gave me just enough information to make me work my way through the problem so was I was able to learn in the process. As I get better in VBA I will pay it forward.:)

pbaldy, Thanks for the help! Moving the quotations and adding the Debug.print was very helpful. I think I made some progress today. I am able to get all of the criteria (both routes I select from the listbox and Date Ranges in enter in to the text box) but it returns a Runtime error 3075...

Hello, I am new to VBA and have a tremendous task dropped on me. Until now I have been able to work through everything or apply code I have found online. I am trying to create a drop down list the will let me choose one or multiple items. In this case Different routes and then I want to the...