Results 1 to 1 of 1
  1. #1
    Join Date
    May 2003
    Location
    Teas
    Posts
    28

    Unanswered: particular query

    Hello,

    I have a list box (name=lstTables) and set to unbound. and Not link to any query. However, I am using following code to pull up all the queries in the database. How do I only pull one particular query call QryRollOver?

    ==============================================
    SELECT MsysObjects.Name AS ObjectName, IIf([type]=1 Or [type]=6,"Table","Query") AS ObjectType FROM MsysObjects WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1 Or (MsysObjects.Type)=5 Or (MsysObjects.Type)=6) AND ((MsysObjects.Flags)=2097152 Or (MsysObjects.Flags)=128 Or (MsysObjects.Flags)=0 Or (MsysObjects.Flags)=16)) ORDER BY MsysObjects.Name;
    ==============================================

    Thanks
    Dianna Jamil
    Last edited by cool_guy_no_1; 09-16-03 at 01:19.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •