MS Access developer question

[dawdy]

I'm designing a database for a small handyman company. The owner would like to be able to input a zip code and have it automatically update the city and state. Anyone know how to implement this in Access?

 

[kamper]

I doubt Access will do that for you (just guessing). You will have to do that in your application on your own.

 

[Descartes]

Man kamper, you're killing me Of course you can do this. If Access were not able to perform such a rudimentary task how could anyone use it?

You need a lookup table. This is very basic Access so I'll leave it as an exercise for you to implement. Google around for tons of examples too. There are other ways to do it, but that's the easiest, imo.

 

[kamper]

D@mn. I thought the idea was quite "out there" but I put the "just guessing" in because I seem to get this sort of thing wrong on a regular basis As usual, thanks for pointing out my incorrectness So Access actually comes pre-populated with a list of zip codes and cities and states?

<-- crawls away and decides not to offer advice on anything for a while

 

[WW]

Originally posted by: kamper
D@mn. I thought the idea was quite "out there" but I put the "just guessing" in because I seem to get this sort of thing wrong on a regular basis As usual, thanks for pointing out my incorrectness So Access actually comes pre-populated with a list of zip codes and cities and states?

<-- crawls away and decides not to offer advice on anything for a while

no, but you can find such lists:

http://www.mikepainter.com/ZIP_Codes/zip_codes.php

then use that info as a lookup table

 

[kamper]

Ah, I thought we were talking about something that a normal database couldn't do. Nice solution.

 

[DJFuji]

lol i was thinking the same thing kamper was. "but theres no built in way for access to resolve cities and states from zip codes..."

>>
Man kamper, you're killing me Of course you can do this. If Access were not able to perform such a rudimentary task how could anyone use it?

You need a secretary to look up the zip codes in the nationwide phone book and tell you what the states and zip are so you can insert them into Access. God! This is so basic. How could you not figure this out? I'll leave this as an exercise for you to implement.

 

[EagleKeeper]

Originally posted by: DJFuji
lol i was thinking the same thing kamper was. "but theres no built in way for access to resolve cities and states from zip codes..."

>>
Man kamper, you're killing me Of course you can do this. If Access were not able to perform such a rudimentary task how could anyone use it?

You need a secretary to look up the zip codes in the nationwide phone book and tell you what the states and zip are so you can insert them into Access. God! This is so basic. How could you not figure this out? I'll leave this as an exercise for you to implement.

You may be able to request the database electronically from the post office.

I developed an application a few years ago that started with an existing database of addresses. When a zipcode ws entered that was unknown, then the user was required to populate the city/state. When known, the city/state was automatically populated.

 

[KLin]

I will only say this. Dlookup()