Being a glutton for punishment (or not know when to say N.O.) I've
stated that I can update our location dictionary with correct address
information. This means connecting to the usps.gov website and
"attempting" to interact with it. Everything was going so smoothly,
until I went to the next record. If I could avoid D.Next_ so many
problems would be self resolving. :)
Here's the problem the TEXT location that I need to view changes for
each record.
I.e. TEXT ("123 my Street*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results") and then
TEXT("456 yours Ave*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results")
Leaving off the street address renders the F("V?") = TEXT (whatever)
useless. I thought I had it figured out by using
F("V?")= TEXT(D("3") & "*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results") 'Since D("3") is my street address
But NOOOOO, Human nature (being what it is) causes me many headaches.
Misspell a word, or leave something as little as a W,E,S or N off the
street name and the script sits there for ever and a day.
Is there a wildcard that could be used in place of D("3")? Or if anyone
is bored, perhaps you can help me figure out what would work? I've
pretty much viewed every element on the page. As far as I can tell,
with out the street address it does not view the text.
So in the end it would look like:
F("V?") = TEXT( ANYTEXT & "*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results") 'Since the results would be the same.
Thanks
p.s. F("V?") = TEXT("*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4 Code
By Address Results") ' Reads no text off the page.
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[EMAIL PROTECTED]
