Michael,
Use error trapping and on the case err.number just do a resume next (next
line of code) or a resume skipline: where you place skipline: at the put you
want the program to contiue.
Please see my signature.
Bob
Michael Scott wrote:
Quote:
>This is driving me nuts. Can anyone help?
>
>I have a program which searches for and analyses Access databases
>across a corporate network. At one point in the code I am looping
>quickly through all the querydefs in the target database to give an
>idea of what we're dealing with:
>
>For each qdf in dbsDiscoveredDatabase.QueryDefs
--
Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com
Message posted via
http://www.accessmonster.com 
