Address Validation using web?

[A|ex]

Is this possible in Microsoft Access? i know its possible in c# but ive never really got into Microsoft Access until now.

Enter a Postcode , logs onto a website and fills in a combo box full of possible addresses

 

[A|ex]

so does anyone know if this is possible? i mean there are many sites out there which offer addressses, postcode lookup etc. Cant i just import the data into access?

 

[stormin_norm]

so does anyone know if this is possible? i mean there are many sites out there which offer addressses, postcode lookup etc. Cant i just import the data into access?

Alex- First, you posted in the Forms Forum. You should have posted in the general section.

What is your ultimate goal? To call a program from within Access which will perform the login & address lookup or to import an external data table into access and do the state/zip checking in access? Two seperate things. I think your users will not like a slow system which has to log into a website to check addresses. Unless you have an internal server which can process these requests at lightning speed and do the web services thing.

There are some big companies out there doing data address cleansing (group1) if thats what you are looking for? So your question depends on how clean an address you want. What should it check city/state/zip or street/city/state/zip or valid house number/city/state/zip?
The more complex. the less likely you'll find a freebie database out there.

 

[A|ex]

i'm not really after a database all i want to do is log onto a web site and validate some details or read in some details.

For example

postcode to postcode

find the difference and display in the database

 

[stormin_norm]

i'm not really after a database all i want to do is log onto a web site and validate some details or read in some details.

For example

postcode to postcode

find the difference and display in the database

So you are doing a simple zip code check. Thats it? No City/State/Zip?
Simply go to the US Postal Service web site

 

[A|ex]

yes something similar but for UK addresses. Type in a postcode and it will automatically populate a combo box with possible STREET addresses. After choosing one it will fill in the city etc for you.

If not all i want it to do is log onto a web site (map site) punch in two post codes, destination and source and work out the distance traveled by reading in the values the site produces

 

[A|ex]

is it possible for a mod to move this to general forum? i want to know if this is possible or not? i dont think VBA supports sockets so i guess its make a c# dll addin for access?