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...
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?
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!
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?
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?
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...
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.
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.
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...
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 & ""
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...