List box with available queries question

  • Thread starter Thread starter Billy B
  • Start date Start date
B

Billy B

I have a list box control on a form and want the list box to display all the
queries within the database. The following code is what I have so far but it
does not work. Any help is appreciated.

SELECT [Name] FROM MSysObjects WHERE [TYPE] = 5 and LEFT([Name],1) <> "-"
ORDER BY [Name];
 
Billy B said:
I have a list box control on a form and want the list box to display all
the
queries within the database. The following code is what I have so far but
it
does not work. Any help is appreciated.

SELECT [Name] FROM MSysObjects WHERE [TYPE] = 5 and LEFT([Name],1) <> "-"
ORDER BY [Name];
Click to expand...


It shouldn't be names starting with "-" that you exclude; it should be names
starting with "~":

SELECT [Name] FROM MSysObjects
WHERE [TYPE] = 5 And LEFT([Name],1) <> "~"
ORDER BY [Name];
 
Back
Top