UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> IsQuery    
' Code courtesy of UtterAccess Wiki
' http://www.utteraccess.com/wiki/index.php/Category:FunctionLibrary
' Original submission by: Brent Spaulding (datAdrenaline)
' Date contributed: 2010-07-27
' You are free to use it in any application,
' provided this copyright notice is left unchanged.

Public Function IsQuery(strQueryName As String) As Boolean
'Determine if the passed string is a Query object in the current database.

   IsQuery = DCount("*", "MSysObjects", "[Name]='" & strQueryName & "' And [Type] = 5")

End Function

Creative Commons License
IsQuery by UtterAccess Wiki is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.
Editing and revision of the content is freely encouraged; for details, see Expected Usage.

Edit Discussion
Custom Search

Thank you for your support!
This page has been accessed 7,000 times.  This page was last modified 09:38, 6 April 2011 by Jack Leach. Contributions by Brent Spaulding  Disclaimers