canadian postal code lookup - Microsoft Access / VBA

Ronnie

Hello there,

I am creating a contact database and I would like my user to enter
postal code (Canadian) and the city/province will be automatically
filled in. I am sure this can be done and I can probably buy the
databse/software, but I was wondering if I can get a free
database/software that can be incorporated in my Access 97 database.

Any help in this regard will be highly appreciated.

Thank you for your time.

Ronnie

Nov 13 '05 #1

Subscribe Post Reply

2209

Paul

Maybe your local post office has the Postal Code book stored electronically.
Just create a table and include the Postal Code, Province & City. Then do a
lookup when a postal code is entered on a form.

HTH
Paul

"Ronnie" <ro*****@yahoo.com> wrote in message
news:a9**************************@posting.google.c om...

Hello there,

I am creating a contact database and I would like my user to enter
postal code (Canadian) and the city/province will be automatically
filled in. I am sure this can be done and I can probably buy the
databse/software, but I was wondering if I can get a free
database/software that can be incorporated in my Access 97 database.

Any help in this regard will be highly appreciated.

Thank you for your time.

Ronnie

Nov 13 '05 #2

Similar topics

Fuzzy matching of postal addresses

by: Andrew McLean | last post by:

I have a problem that is suspect isn't unusual and I'm looking to see if there is any code available to help. I've Googled without success. Basically, I have two databases containing lists of...

Python

Distance Between Postal Codes

by: Dave \IT\ | last post by:

I'm looking to find out how I'd go about setting up a database where a visitor to my site could punch in their postal code, and find out how far they are from another postal code. For example,...

Microsoft SQL Server

Philosophical issue - problems of distinction between code and data

by: Steve Jorgensen | last post by:

Hi folks, I'm posting this message because it's an issue I come up against relatively often, but I can't find any writings on the subject, and I haven't been able to figure out even what key...

Microsoft Access / VBA

9 digit postal codes on mailing labels

by: Bobbie | last post by:

I am trying to make mailing labels. The zip/postal codes are 9 digits (ex: 40601-0223) I ran a query and put in the input mask 00000/-9999;;_ and it works but when I make the mailing labels and...

Microsoft Access / VBA

Postal code processing with .NET regex

by: Surfdog | last post by:

Hello all, I'm unable to figure out how to process the zip codes with regexes. We have a custom component that takes a find pattern, a replace pattern, and the input value, and will output the...

C# / C Sharp

Shocking Autobiography Published "Canada's Spies Attacked Me: A True Story of CSIS Terrorizing a Canadian Abroad"

by: mgtimelogger | last post by:

The Canadian government would rather program peoples minds than in C. See below. Shocking New Book Published "Canada's Spies Attacked Me: A True Story of CSIS Terrorizing a Canadian Abroad" ...

C / C++

New Postal Verification SErvice: NCOALink

by: pwilliams | last post by:

NCOALink Change of Address Verification Each year over 40 million Americans change their mailing addresses. This change is equivalent to every person in California deciding to change addresses...

Microsoft Access / VBA

Can anybody share me the Canadian PostCode Database

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...

PHP

Reading Code/Description lookup via inline XSLT

by: ianoble | last post by:

I've been trying to piece together various code snippets to create a lookup table inside my xslt without the need for a supplemental xml file. Here is what I have so far. As of now, it does not...

XML

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware