"Ambiguous outer joins" error when looping through querydefs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Scott - 08 Nov 2007 09:57 GMT

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

Reply to this Message

heifler - 09 Nov 2007 21:22 GMT

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

>This is driving me nuts. Can anyone help?
>
[quoted text clipped - 4 lines]
>
>For each qdf in dbsDiscoveredDatabase.QueryDefs

Signature

Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com

Reply to this Message