>I'm trying to remove records in one table that match those in another table.
>I have the following code but this seems to make Access 'Hang'. Is this the
[quoted text clipped - 55 lines]
>
>End Sub
Thanks for the advice. I had been experimenting with SQL but I'm fairly new
to it and was getting a 'Must use an updatable query' error that I couldn't
seem to solve.
The assumption that there is never more than 1 person with the same name in
each postcode is fairly shaky, but as each postcode relates to a maximum of
80 households and there are no other unique identifiers for the records, it's
the best I can do. It should serve the purpose with the least amount of
error.
By the way, what does 'air code' mean?
Thanks
> >I'm trying to remove records in one table that match those in another table.
> >I have the following code but this seems to make Access 'Hang'. Is this the
[quoted text clipped - 87 lines]
> last name in a zip code area. This is a very shaky
> assumption.
rjphillips - 15 Mar 2005 14:57 GMT
I've tried your code and indexing the fields to be searched and thats worked
a treat!
Thanks for your help Marshall. In other forums you can award points to
people who've provided help. Not in this one though, so you're just going to
have to be content with the knowledge that you've reduced my stress levels
and stopped me shouting at my computer!
> Thanks for the advice. I had been experimenting with SQL but I'm fairly new
> to it and was getting a 'Must use an updatable query' error that I couldn't
[quoted text clipped - 101 lines]
> > last name in a zip code area. This is a very shaky
> > assumption.
Marshall Barton - 15 Mar 2005 17:39 GMT
Glad to hear you got it working.
Good luck with the potential name/zip conflicts. I'm afraid
luck is about all you've got going for you on this issue.
My wife runs into this kind of problem at some local shops
where there is another Margaret Barton with the same zip and
the two phone numbers are xxx-yyy-9665 and xxx-yyy-9656.
Air code is untested code that is just typed into a post,
not Copy/Pasted from a successful test program.

Signature
Marsh
MVP [MS Access]
>Thanks for the advice. I had been experimenting with SQL but I'm fairly new
>to it and was getting a 'Must use an updatable query' error that I couldn't
[quoted text clipped - 11 lines]
>> >I have the following code but this seems to make Access 'Hang'. Is this the
>> >best/correct way of performing this type of operation?
[snip]
>> I can't say why the RecordCount seems off, but your code
>> will run forever because you forgot the MoveNext in some of
[quoted text clipped - 27 lines]
>> last name in a zip code area. This is a very shaky
>> assumption.