Search results

  1. T

    Query design to search multiple ranges

    Hi everyone! I've been asked to create a query using Design View (not SQL) to compare addresses in a table to addresses in another table that are listed in ranges and provide a list of addresses that match the ranges and a list that do not match the ranges. So, these are examples of the...
  2. T

    Solved "None" in query

    Brilliant! That works! Thanks again @arnelgp !!
  3. T

    Solved "None" in query

    I attached a much condensed version. Please examine the NB_Search form
  4. T

    Solved "None" in query

    Well, interesting idea...but same result. The word None is still there in the list. Could I possibly filter it out using the Properties of the Combo Box?
  5. T

    Solved "None" in query

    Okay, I changed it to Is Not Null. Sorry, "didn't work" meant that the word "None" still appears in the drop down list. Thanks!
  6. T

    Solved "None" in query

    Unfortunately, it didn't work. Is this how you suggested I try it?
  7. T

    Solved "None" in query

    The Row Source is the query which has a criteria of Not is Null already
  8. T

    Solved "None" in query

    Sorry, newbie question: I have a query that is attached to a drop down list in a form that includes the word "None". Can I exclude "None" from the drop down menu? My ideas on how to solve this confuse "None" with Null or "0". Thanks!
  9. T

    Solved Combined results in multi user search queries

    Thanks @MajP & @theDBguy for all of your invaluable help and to the others that also tried to assist! Your are amazing!
  10. T

    Solved Combined results in multi user search queries

    3. Make sure ID is in the form's query. - That's what it is. I substituted the sample data for the real data which does not have the ID column. Is the ID essential to the query?
  11. T

    Solved Combined results in multi user search queries

    One more question @MajP ... When opening the form, a pop up appears looking for a parameter I press OK and is goes away. I'm just wondering what is causing this prompt?
  12. T

    Solved Combined results in multi user search queries

    @MajP Perfect!! That's exactly what I was looking for!! I'm impressed how fast you create the code!
  13. T

    Solved Combined results in multi user search queries

    I've seen these examples and I like them. It doesn't work for ranges however. If the range starts at 1 and ends at 5, it won't find 2,3 or 4. I am intrigued by your Test_MajP zip file. You were able to have the street number filter within the range. This is what I'm trying to accomplish...
  14. T

    Solved Combined results in multi user search queries

    I don't mind it @MajP . I'm curious to know how it would do with a full 60000+ records where the drop downs could be quite long depending on how big the street is.
  15. T

    Solved Combined results in multi user search queries

    It is an interesting method that could work. My concerns are that it could be difficult when sorting through 60000+ records and also finding a street number within the address range. I'd like to test it out to see how easy or difficult it may be for the users.
  16. T

    Solved Combined results in multi user search queries

    @theDBguy I've made a sample database. Please let me know if I uploaded it correctly.
  17. T

    Solved Combined results in multi user search queries

    Tried it and the form works but it doesn't give results for the street number. I tried many variations of the code but without any luck. So, I tried another way. Keeping in mind that we are working with numbers at this part of the search. This didn't work either but there are no error...
  18. T

    Solved Combined results in multi user search queries

    I should remove the * from - strWhere = strWhere & " AND Odd_Start >= '*" & Me.txtStNum & "*' " ? How would I rewrite that? Like this? strWhere = strWhere & " AND Odd_Start >= '*" & Me.txtStNum & ""
  19. T

    Solved Combined results in multi user search queries

    Sorry @theDBguy ... I'm learning on the fly! Okay, I changed it to Me.RecordSource = "SELECT * FROM Ontario" and the form is working. I just have a little fine turning to do on the street number search. I need the search to find any number in the range, so I modified the street number search...
  20. T

    Solved Combined results in multi user search queries

    Okay @theDBguy , I pretty much copied what you suggested: Did I take out too much?
Top Bottom