View Single Post

  #2 (permalink)  
Old 01-09-2003
JPeters JPeters is offline
Junior Member
Yellow Belt
 
Join Date: Jul 2002
Posts: 12
Send a message via ICQ to JPeters Send a message via AIM to JPeters
Fixxed it ... well, this is a simpler fix for my direct problem since I'm only fixing 15 records and any records post this date will not allow po boxes to be entered in the address field... so this works for me. But I might suggest a more extensive solution for someone with a more elaborate problem. Perhaps scan the entire string for the word Box and if it exists create an input box popup for the user to view the address and ask him whether to include it or not, if his answer is yes, then add the record, else move next ... Instruct your users to not allow po boxes, and you can even include this in the popup ... and then if the user accidentally clicks yes on a po box, you can have some error control in your module. I hope this helps someone in the future.

If Left(MapRST!Address, 4) <> "PO B" Then 'Catches Bin or Box
Mapping comands here...
End If
MapRST.MoveNext

-Josh
__________________
---------------------------
-JPeters-
jpeters@guidemail.com
---------------------------
Reply With Quote