473,320 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

PostCode-Zipcode

Hi there I am new to this and would like to know how to input a
postcode/Zipcode I know it goes something like this 00000\-9999 or LL0\-LL3
so this codes will cover numbers as zipcode like this 12345 7890 and
Letters & Numbers AA7 BB1 what I need to know is the code to put in a post
code like this (BT7 2EN and this BT37 2RJ) with just one code I need the
code so I can input any of the above please help
Nov 13 '05 #1
3 1762
What countries could the data be coming from? Different places have
different arrangements; US ZIP codes are 00000\-9999, but if you're dealing
with Canadian, UK, and other postal codes it gets very complicated very
fast! If you are going to have a whole range of them, and not few enough
just to create separate fields for each type, all you can do is have a text
field and make sure you input carefully, otherwise you'll need a lot of code
to cover every possibility.

"Sean" <se*****@ntlworld.com> wrote in message
news:o3*****************@newsfe6-win.ntli.net...
Hi there I am new to this and would like to know how to input a
postcode/Zipcode I know it goes something like this 00000\-9999 or
LL0\-LL3 so this codes will cover numbers as zipcode like this 12345 7890
and Letters & Numbers AA7 BB1 what I need to know is the code to put in a
post code like this (BT7 2EN and this BT37 2RJ) with just one code I need
the code so I can input any of the above please help

Nov 13 '05 #2

OK the code I need is for the UK only thank you for taking the time to
reply.
*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3
There's some code here that will get you started:

http://www.mvps.org/access/modules/mdl0063.htm

"sean Beckett" <se*****@ntlworld.com> wrote in message
news:xW***************@news.uswest.net...

OK the code I need is for the UK only thank you for taking the time to
reply.
*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Nazir | last post by:
Hi - I know this isn't really a specific SQL Server question but I can't think of a better forum. I want to implement a more sophisticated UK postcode search on a site - "LIKE 'NW%'" etc, is not...
5
by: Mike Price | last post by:
This may seem simple but I need to validate the postcode properly from an Access form. I know loads of other people have done this so I was wondering if someone could show me how - either by an...
5
by: Lapchien | last post by:
I have a field for a postcode. I'd like another field to auto contain an 'area' number, based on the first part (only) of the postcode. For example, if a postcode LS4 4DJ was entered, another...
5
by: Alan | last post by:
Hi, I'm getting as bit confused with my queries. I simply (!) want to insert a space into a postcode field the 4th character from the right, so, for example, ML201TQ becomes ML20 1TQ, which is...
6
by: Julian | last post by:
Hi, I am a very beginner in databases. I created a database table in Access 2003 and OOo 2.03 that includes name, address, postcode, phone numbers etc of our customers. I would like to sort...
3
by: mark | last post by:
I have a table of UK companies whose records I want to filter using a map of postcode regions. For the benfit of people outside the UK, our postcodes are a pain to work with because they are not...
12
by: xhe | last post by:
I am now developing a website which needs Canadian PostCode Database. I can certainly buy one, but that will cost my hundered of $$, and my website is only for education purpose, it won't make...
5
by: billynastie2007 | last post by:
Hi i am writing a balloon race site and i am having problems with some functions to calculate the distance the balloon travels firstly i am reading my info from the database using the fetch assoc...
0
by: Pinna | last post by:
Hiya, I am trying to select based on a range on postcode on a table. The field POSTCODE is a varchar2(8). The problem is when refinng on 'where postcode between 'PE1' and 'PE29'', because this is...
1
by: dominicowen | last post by:
Hi, I have a customer database in Access 2003 with customers postcodes. What I want to do is type in a postcode on access and it will link the postcode on to googlemaps without having to type...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.