ZipCode LookUp Changes - Access Developer Network


	Back to Access Developer Network Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

ZipCode LookUp Changes

David Pierce

5 years ago

Hi All,
Maybe you would be interested in makeing some changes to the ZipCode LookUp Paid version that is on this site. What I would like done is the following:
Remove Edit Button
Replace Txt box "Zip" with a combo, add a not in list event to add, dbl click event to edit.
Replace the Txt Box "City" with a combo, If more than one city is in table for that zip, then auto expand (drop) to choose a city. Also adding a not in list event to add a new city if typed over..... If that makes sense?
Let me know if interested and a cost to complete it.
Thanks
David

Ray White @Reply

5 years ago

Hi David
Just a thought on the Txt Box " Zip "
Why would you want a Combo Box?
It will slow down the forms load time having to load all of the Zip Codes in that Combo Box.
After you get 1000s of Zip Codes in that database you will see.
The Zip field already has code to check if the Zip Code is in the Zip database
and if not it will open the ZipLookupF form so you can add the new Zip Code.
And for the " dbl click Zip field event to Edit"
just take the code form the Edit button and place it in the Dbl click event in the Zip field.
Hope this helps.
Ray

	Richard Rost @Reply 5 years ago
I agree with Ray. Making it a combo box will slow it down a lot once you get lots of records in there. If anything you could make the ZIP lookup text box a search as you type box that populates a listbox or something.

	David Pierce OP @Reply 5 years ago
Thanks all, I did some playing with it and it actually does what it's supose to. Me Bad! Also, I wasnt aware that a combo would slow it down either so that is nice to know. Thanks again...

	Ray White @Reply 5 years ago
"Search as you type" is exactly what I had to do with my Zip, City Combo box. I had 9000K records and you talking about slowing down a Combo box. Sloooow. "Search as you type" is the way to go with that many records.

	Richard Rost @Reply 5 years ago
What Ray said. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Network.

Next Unseen

New Feature: Comment Live View