LinkBack URL
About LinkBacks
Is it possible to buid a forem where the user just type house no and postcode and the corresponding address should automatically display on the address textboxes.
Can anyone please help me to build this up?
Thanks
Aman
Is it possible to buid a forem where the user just type house no and postcode and the corresponding address should automatically display on the address textboxes.
Can anyone please help me to build this up?
Thanks
Aman
Re: display address corresponding to postcode and house no
Good morning aman1234
Yes, tt is certainly possible to do this.Originally Posted by aman1234
Is it possible using Excel? No is the short answer. With somewhere in the region of 2.5 million active postcodes in the UK you wouldn't have nearly enough rows using Excel 2003 and still not enough using Excel 2007. I also don't think that Excel has powerfull enough interrogation facilities to enable this.
There are several companies offering software or online tools to do this. Try Googling for some. There doesn't seem to be much in the way of free - obviously a lot of work goes into this sort of thing.
http://www.postcoder.com/handy_tools/postcode_lookup
HTH
DominicB
Last edited by dominicb; 05-12-2010 at 06:46 AM.
Please familiarise yourself with the rules before posting. You can find them here.
Thanks dominic
In my project, Excel is the frontend and access is the backend. Is it possible if I store them in access table and display the corresponding address on the textboxes in the userform.
Thanks
Aman
Can anyone please tell me Is it possible if Access is the backend and excel is the frontend?
Thanks
Yes, it is possible assuming you have all the postcodes in the database and that you have the house numbers as a separate field.
Everyone who confuses correlation and causation ends up dead.
You can find a database (SQL and CVS files) for UK postnumbers here
I've also attached a sample workbook that chooses correct city based on postal number.
Last edited by wamp; 05-12-2010 at 09:21 AM.
Thanks wamp
Can you please send me the vba code to display the whole address instead of only city in the textboxes depending upon the postcode and house number please. The database needs to be access?
Thanks
Aman
Thanks romper for your reply. Can you please send me the complete code to acheive this?
I hope you will help me out.
Thanks
Aman
Since I don't know anything about your database or how you plan to input these values, no I can't give you complete code.
Ok. uploaded the changed workbook.
No, I can't.Can you please send me the vba code to display the whole address instead of only city in the textboxes depending upon the postcode and house number please. The database needs to be access?
Like dominic said, it's not possible to display 2,5++million addresses in excel
Thus, if you want to extract a complete address with only a postcode and a housenumber to go on (enter), you'd still get multiple hits, as many housenumbers are the same within a single postal-region.
That would be IF you had a database containing all this information.
and even then, II assume there are also many addresses througout the UK with exactly the same names in them, thus ever-changing streetnames due to new buildings etc. etc.so it would be a database that'd be "impossible" to maintain unless you have a fulltime job in the postoffice, doing just that :-p
Romper, I don't have anything in the databse.My manager just asked me can you find the complete address depending upon the postcode and house number entered by the user.
The address will then be stored in the textboxes.
But I don't know how to do it as for this I need all the addresses,house numbers and postcodes then search from the database the record that matches with house number and postcode entered in the textboxes.
I really have no idea thats why I need your help.
Thanks
Aman
Tell him no.
If you don't already have the data, then you will need to get it from somewhere, and it almost certainly won't be free.
[removed - will leave it to Moomin]
;-)
Last edited by wamp; 05-12-2010 at 09:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks