Select Queries to appear in listbox

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi, I need to list all the queries which i want to see on
a listbox. How can i do it?
I only have codes which allow me to display ALL the
queries found in my database.

Here is 1 of them... Row Source ---> SELECT
MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name
Not Like
"~sq*" AND MSysObjects.Type=5

Can some1 tell me how i can manipulate the above codes to
list only the queries i want to appear in a listbox?
Thanks!
 
Which queries do you want to see?

You could store the names in a table, then use that table
as a rowsource for the list box. Or, you could use a
value list and hard code them.

We need a little more info to provide assistance.


Chris
 
Hi Chris,

The code which was given to me as shown --> SELECT
MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name
Not Like "~sq*" AND MSysObjects.Type=5
allows me to view ALL the queries which i have actually
created in my Access Database.

For example, I have 3 queries in my DB, "Query1", "Query2"
and "Query3". I only want to show "Query1" and "Query2" in
my listbox which will be found on a form. How can i
actually do this??
 
Back
Top