Postcode

Mar 6, 2006

I need to know how to be able to make my database accept only postcode format entries like RT24 6QP (english). Like a validation , it would only accept that format. How would i go about doing that.
Please explain to be in easy to understand contex as im no expert with access.

Thanks

View Replies


ADVERTISEMENT

Find Postcode

Jun 21, 2007

Hi, I am inputing addresses into a massive databse, through a form, does anyone know a way, that i can get it to do a search for the address based on the postcode, like how googlemaps does it or something?

Thanks
Alex

View 2 Replies View Related

PostCode Lookup

Jul 4, 2007

I was wondering if anyone had any experience of integrating a product like QuickAddress (QAS) into an Access Database to aid the completion of address details. ThanksRussG

View 6 Replies View Related

Postcode Problems

Jul 8, 2005

Hi Guys,

I have searched the forum, and not really found the answer I`m looking for.
I used in my Database, a postcode field, which for 90% of the postcodes I input is is fine.

However, som of the postcodes dont conform to standard post codes.

I`ve found some info in this link, http://www.access-programmers.co.uk/forums/showthread.php?t=89393&highlight=links

but this didnt really help.

Most postcodes ( as set in the database properties ) confirm to thiis standard

SK01 1AA

Which if intered in this format works all OK.

However, some postcodes go in as fiollows

M01 1AA

Which leaves me a digit short, and messes up my search sections of the database, and the link to external map programs like M$ Mappoint.

Is there anyway that anyone knows of that will sort this out, and allow both entries withouht screwing up other programs.

This field is also a REQUIRED field, and must be a data field, or my external program links like M$ Map Point wont work.


THanks in advance guys.

Max

View 12 Replies View Related

Postcode Validation

Mar 20, 2006

hello all
this thing is really bugging me im trying to come up with a post code validation and i have tried dozens, which should have worked really, but just havent so wondering if you guys knew any
examples of postcodes would be

BN3 8JH
BN41 8JH

theyre the only two types that are bound to be entered really

the first and second characters have to be a letters
the 3rd has to be a number
the 4th is sometimes a letter (not always present)
then theres a space
then there has to be a number
letter
letter

any suggestive codes would be great, as none of mine have worked its in access

thanks
nightmare lol

View 1 Replies View Related

UK Postcode Field Validation

Nov 1, 2006

Hi,

I have a postcode field on a form that allows 8 characters. e.g. ST10 8BY including the space in the middle.
The only validation I have been able to use thus far is the above but I would like to know how to validate two letters (AA) then between 1 and 2 numbers (11) etc.

Is there any code/built in functions that allows this. I know there is an input mask but if I use that, I can set the poscode format up like ST10 8BY but it thinks that the rule has been broken if the postcode was changed to S10 8BY by removing the T. This is also a valid postcode.

Does anyone have any suggestions?

Thanks

View 3 Replies View Related

Postcode Web Database Lookup...

Dec 3, 2006

hi guys,

Just been asked this and not sure if it is possible...

they do not want to pay loads of money to the royal mail for their postcode/address data. but they want a faster way (like typing postcode and address options popup) of entering addresses. There are tons of websites that can be used to find addresses with a postcode, i was wondering if it was possible to somehow link the database to lookup address from a website...?

anyone got any ideas?


thanks, james

View 11 Replies View Related

Still Having Problems With Postcode Query

Jul 8, 2005

Am trying to query a customer database to find a how many instances of each postcode exist to determine geographic distribution. Only interested in the first part of the postcode so the following code was suggested:

SELECT Count(owners.Field8) AS Total, Left$([Field8], Len([Field8])-3) AS Code
FROM owners;

However it returned a message saying "you tried to execute a query that does not include the specified expression 'Left$([Field8], Len([Field8])-3)' as part of an aggregate funtion.

What does this mean? :confused:

View 1 Replies View Related

Postcode Ranges Question

Jul 27, 2005

Hi all,

I am relatively new to access and need some help.

I have table with ranges of postcodes (NL) and regions. For instance

Table_Regions_Range:
Amsterdam 1000-1119
Haarlem 2000-2099
etc

And i have a records of schools:

Table_Schools:
SchoolA 1050
SchoolB 2050
etc

I want to query the data base and lookup in wich regio a school is based.

Where do I begin?

Thanx in advanced

Jan

View 1 Replies View Related

Postcode Count Query

Jun 5, 2006

Hi All,
Can anyone help me count postcode instances. I have a query that looks at my customers table (tbl_Customer_Details) post code field (PostCode), at the moment I have got it to strip out the right side of the postcode leaving me the left district side eg. HG12 8EN becomes HG12. I would then like to count how many times each postcode instance occurs so I can create a report on the result so I can track which district the customers are coming from. I hope this explains the problem. Any help would be mich appreciated.

SELECT tbl_Customer_Details.PostCode, Left([Postcode],4) AS Code
FROM tbl_Customer_Details
GROUP BY tbl_Customer_Details.PostCode;

View 4 Replies View Related

Modules & VBA :: SQL Postcode Validation

Jul 10, 2015

I've tried to steal an SQL Postcode validator (This is for UK postcodes) and add it to an AfterUpdate event on a field in MS Access. It doesn't work, obviously,The VBA code is:

Private Sub Postal_Code_AfterUpdate()
Dim CHECK_Code As Integer
Dim LResponse As Integer
If InStr("[A-Z][0-9] [0-9][A-Z][A-Z]", Postal_Code) = 0 Then
CHECK_Code = 0

[code]....

Also, how would I put the Check_Code value into the Message box to see what it's bringing back?

View 8 Replies View Related

Format For UK Postcode Input Into Table

Feb 21, 2006

I guess this is pretty fundamental but I cant get it right! I want to search for a member by post code so I need to have validation for my table field post code so that when my parameter query accepts the post code input records will be returned covering all input types e.g. Users can put in CF72 (space)9AD or CF729AD and still get the same records or alternately how do I make users enter Post Codes with the correct UK spacing i.e 4 characters a space then the remaining characters?

View 7 Replies View Related

Query On Part Of A Postcode Field

Jul 7, 2005

Hello all!

I have a customer database and I basically want to find out their geographical distribution. To do this I need to run a query that gives me the sum of customers for each postcode, but this is dependent on only the first few characters of the postcodes (or prefix), eg BH3. The length of the prefix varies between 2 characters and 4 characters with one or two characters followed by one or two numbers.

What I don't want to happen for example is to have postcodes counted as BH1 when in fact they are BH13 or to have postcodes coutned as BH13 when they are actually BH1 3LV.

Does anyone have any suggestions of how I can do this? :confused:

Any help most gratefully received!

:)

View 8 Replies View Related

Extract UK Postcode With Expression In Query

Jan 19, 2006

Hi

If i wanted to run a query from customer records in my database and wanted a list of specific postcodes that matched the criteria how would i do this?

For example each customer records has a postcode BD4 4KL, LS9 7YH ETC

I want to categorise each postcode set to see for example all the customers with postcodes begining with have ordered factsheets.

In the criteria part of the query how would i write it so it only extracts specific postcodes from the database from the ones i require

e.g "HU1, HU2, HU3 HU4" - checks database - returns all postcodes beginning with this.

Please help me!

Thanks

View 14 Replies View Related

UK Postcode / ZIP Code Input Mask

Apr 2, 2012

The problem with UK postcodes is that there are 6 different formats. These are:

A9 9AA
A99 9AA
AA9 9AA
AA99 9AA
A9A 9AA
AA9A 9AA

I've seen on similar threads where people have just forced the field into capitals, but my data requires that it is a valid postcode and I cant find an input mask that allows all UK postcode.

View 1 Replies View Related

Queries :: Count Matching Postcode Between Two Tables

Sep 1, 2014

I have two tables, one being an 'Address' file and the other an 'Area' file which is a list columns ranging from 1-400 with groups of district level postcodes. For Example; column 1 will have postcodes such as BN1, BN2, BN3, BN4, BN5 etc. Each column has a separate group of postcodes.

Now, my 'Address' file also has a column within this labelled 'District' in order for me to create a straight join (between column number and District) in a query to count each group individually, but of course, do to this 400 times becomes quite tedious! (to say the least)

I would require the outcome to be as follows :

Area file - Count
1 - 469
2 - 201
3 - 0
4 - 3598
5 - 268
. - 101
. - 8936
. - 563
399 - 287
400 - 41

View 5 Replies View Related

General :: How To Link Customer To Postcode Table

Mar 6, 2014

I am using access 2010 and have the following question?

I have 2 tables, 1 called UKFile and the other Customers with the following fields

[UKFILE] THIS IS WHERE ADDRESS DETAILS ARE STORED
POSTCODEID
POSTCODE
STREET
TOWN

[CUSTOMERS]
CUSTOMERNAME
POSTCODE
STREET
TOWN
CONTACTNAME
TELEPHONE

How do I link these so that when I enter the customers postcode it grabs the data from the UKFile table.

Should I change structure at this early stage,

View 2 Replies View Related

General :: Extract Postcode From String - No Other Filtering

Dec 31, 2014

I have tried to find this on the forum but it seems all the answers are to do with manipulating the strings based on what the postcode is whereas I just want to extract the postcode as a separate string as simply as possible.

Basically, I have a text field called Add5 which has the last line of the address including the postcode.

Example: "Northampton NN1 7PQ"

I am trying to end up with two strings like this

Add5 = "Northampton"
Postcode = "NN1 7PQ"

I only need to do this in one place, I don't think it needs a module.

View 5 Replies View Related

General :: Extract Part Of Postcode Field

Feb 12, 2015

I have a table with about 29,000 postcode values

I want to extraxct the first part of the field (usually 3 or 4 characters)

How can I automate this?

View 2 Replies View Related

Queries :: Postcode Extraction When There Are Double Space On Some And Not Others

Feb 4, 2015

Any way to extract a postcode when there are double space on some and not others.

SA1 1AB (i need SA1 1AB)
HU1 2AB (i need HU1 2AB)
HU17 0BG (ok)

For some reason the postcode field returns 2 spaces when the postcode length is only 6 digits and 3 spaces when the postcode length is only 5 digits. Im assuming that the postcode field needs to be 8 characters in length (including a space).

All I want to to remove the addition spaces and return a normal looking postcode!

View 11 Replies View Related

Queries :: Extract PostCode Values From The Field

Feb 4, 2014

I have a table with a string field included for an address.

Some rows have postcodes and some dont

How can I extract the PostCode values from the field?

View 14 Replies View Related

Forms :: Get Part Value From Postcode To Create Cost

Mar 26, 2014

I have a form which has a number of fields and 2 of them are called [Postcode] and [Cost].

The cost field is defaulted to "£75.00"

What I am trying to is after the user enters the postcode it looks at the first and second value and if they enter a postcode in Scotland like below it changes the cost field accordingly.

The changes will only effect postcodes in Scotland if that makes sense as we have 2 different pricing areas for these

examples of some postcodes
AB1 1AU £125.00
EH1 1RT £85.00
G1 1AT £85.00
IV5 1ER £125.00
ML1 1RT £85.00
and so on

so any postcode containing the following would update

AB = 125
EH = 85
G = 85
IV = 125
ML = 85
DD = 85
FK = 125
etc etc

all other postcodes in the uk will show the default value of £75.00

View 9 Replies View Related

Queries :: Count Number Of Society Members In Particular Postcode Area

Sep 16, 2013

I have a query to count the number of society members in a particular UK Postcode area. It works well for a single Postcode reference but adding further references to the Query Design View generates an 'or' or 'and' statement, rather than the additional counts that I need.

The SQL code I use for a single reference is :
SELECT Count([Mail List].[PostCode]) AS CountofPostCodeH
FROM [Mail List]
WHERE ((([Mail List].PostCode) Like "BN5 ???"));

How do I amend this code to produce counts for multiple references in one query.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved