to simplify:

I have an Access database with a table TAB1 that has an element EMAIL and I want VBA code that will romp through all of the EMAIL elements of the table so that I can do various tests on the EMAIL string. I have two problems; first I can't find a way to have the VBA code reference the EMAIL elements, and second I can't find a property that will tell me how many rows are in the table. If I could make the FOR EACH work with the table rows as a collection (which I can't figure out how to do either), I wouldn't need the # of rows, but I'd like to know how to get it anyway.

This all seems as though it should be really simple, but I'm stumped. I'm a newbie using VBA in MS Access 2000

Thanks for your time.

Paul Hinds
[email protected]