Re: How to Validate Address?

vunet.us@xxxxxxxxx wrote:

On Jun 19, 12:56 pm, "Jukka K. Korpela" <jkorp...@xxxxxxxxx> wrote:
Scripsit Beauregard T. Shagnasty:

A visitor, once realizing you are checking zipcodes, may still enter a
bogus name and street address.

Or he may move to a better site.

Any checks have the risk of rejecting correct data. It's actually _very_
difficult to check even an e-mail address reliably. Zip codes might be
easier since they constitute a finite and known set, but what happens when
the set changes, e.g. new codes are added?

What happens is that the next quarterly subscription update to the
zipcode database should reflect the new codes. ;-)

What if I use google map to determine a valid address? I'd get HTML of
the map page with user-supplied 'loc' string and if google does not
find it (will contain string "No match found" inside) I will alert the
user of a wrong address entered...?

That won't work. I just typed a non-existent street address for my
street, and google maps quickly showed me the woods nearby, where no
house exists.

And you will never be able to check for valid names.

I run the computers for an annual event's registration, where there are
normally a bit over a thousand people. Using my up-to-date US and
Canadian zip/postal code databases, I always get forms with zip and
postal codes not in the latest databases. Whether or not the people are
writing down correct numbers (and letters), I have no way to tell. So I
accept them, and add them to the database with a marker signifying
'added at the event.' Then I check later...

--
-bts
-Motorcycles defy gravity; cars just suck
.

Relevant Pages

  • radius search
    ... The hard part is your database, which will need to include lat/lon ... you're looking for US zip codes, of course...most countries use a term ... Google Maps Javascript API to do the initial lat/lon calculations, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to Validate Address?
    ... Zip codes might be ... zipcode database should reflect the new codes. ... find it (will contain string "No match found" inside) I will alert the ... street, and google maps quickly showed me the woods nearby, where no ...
    (alt.html)
  • Re: Only displaying the form window
    ... This database has a startup ... I was puting the codes ... > startup form and just use the main switchboard, ... I don't have Access 2003 installed, but if its version of the Northwind ...
    (microsoft.public.access.forms)
  • Re: Advice for field structure or query structure - not getting the results I thought I should
    ... the heart of any relational database. ... For example, since one document may have multiple authors, and one author can write multiple documents over time, there is actually a many-to-many relationship between documents and authors. ... text field 255 character limit) ... CPT codes. ...
    (microsoft.public.access.reports)
  • Re: Comparing contents of two spreadsheets and outputting results to a
    ... is in Sheet1, zip codes in col A from row2 down ... > I have the following - a large contact database is XLS format with address ...
    (microsoft.public.excel.worksheet.functions)