View Single Post

  #1 (permalink)  
Old 02-17-2004
Anonymous Anonymous is offline
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Check error with VBA before adding pushpin

Here's my problem: I'm using a DB where I read streets, cuty names, postalcodes,... from.
The intention is to add a pushpin on every place described in the DB. But sometimes it happens that a street is mistyped which cause an error or a wrong placed pushpin.
For example: The original name is 'PaardeKerkhof'. But if I take Paardenkerkhof, then he puts a pushpin on the other sideof the country (for the curious people: Belgium)
Is there a way that I will always be sure that the placed pushpin is the wright one, in such a way that the users don't has to check all records (probably more than 1000 records)
Reply With Quote