Recent content by timjfletcher

Thanks again for the update. I think I will ignore the 2nd stage for the time being which involves identifying first floor flats etc. However, it would be really useful if you could let me know the amended code so that if a number is followed by a letter (a-z), and then by a space, then...

Many thanks for your quick replies. I would like to use an autonumber, however this would not allow linking/matching to other databases, as the autonumber is only unique to that database. I like the idea of identifying numbers followed by a single letter followed by a space. This would solve...

Hi everyone, I am currently developing a unique property reference (flatnumber+housenumber+postcode) for use across various databases which may refer to addresses in different formats. *running the code through Access 2007. I have used the following code to extract just the numbers in a...