http://vstoolsforum.com/blogs/microsoft_access/default.aspxTricks and Tips for Microsoft AccessenCommunityServer 2007 SP2 (Build: 20611.960)http://vstoolsforum.com/blogs/microsoft_access/archive/2009/02/26/code-to-loop-through-the-querydefs-collection-in-access.aspx#1779Tue, 05 May 2009 16:30:35 GMT05d3ee43-09e1-4c21-9d53-64ecaf1acc4f:1779Graham<p>That is a neat peice of coding.</p> <p>I commented out the if instr section to</p> <p>get a list of all the sql statements in my database.</p> <p>This is a useful function to review all the queries in the current database.</p> <img src="http://vstoolsforum.com/aggbug.aspx?PostID=1779" width="1" height="1">http://vstoolsforum.com/blogs/microsoft_access/archive/2007/08/25/get-the-current-user.aspx#1119Wed, 02 Jul 2008 11:40:32 GMT05d3ee43-09e1-4c21-9d53-64ecaf1acc4f:1119Roy Lawrence<p>Brilliant.</p> <p>Why can't Microsoft tell you things like this!</p> <img src="http://vstoolsforum.com/aggbug.aspx?PostID=1119" width="1" height="1">