Okay, I have a quick question for all of you. I'm using VBA in access to create maps... and my maps will appear fine with pushpins in the location of each record... however, if the automation process comes upon a single PO BOX in the address field of a record- Access stops the mapping process and delivers an error message... I was wondering if any of you know a solution to this problem.
I had considered writing an algorithm that checks the first 6 chars of the address string and sees if it's "PO BOX" or "PO BIN", but unfortunately I'm a much better java programmer than a VBA programer, and I'm not very good at manipulating the string object class in VBA. I could write the code in java in less than a minute so it can't be too tough to write in VBA. Has anyone ever done something like this and could throw the snippit of code my way? Otherwise I'm going to start hittin the books and read up on VBA strings.
I'm hoping that there is an easier way to do this... Considering only 15 of the records in about 5000 have po box in the address field, this is a pain for such little benefit, but it has to be done. Maybe I can write some sort of a query, I don't know... I just need a good shove in the right direction. Thanks much.