Re: How to list all queries only of a database in a combobox.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Type -32768 will give you the forms. Try type 5.

Hint: you could find this out for yourself if you change the WHERE clause to
the name of a query, and see what Type it is.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"xpengi" <xpengi.1s0eo0@> wrote in message
news:VLadnfYjpo-UHk_fRVn_vg@xxxxxxxxxxxxxxx
>
> hi guys,
>
> i got idea from other post to list all tables & queries of a database
> in a combobox with
>
> "SELECT [Name] FROM MSysObjects WHERE [Type] = -32768",
>
> is there way to list all queries only?
>
> many thanks.
>
>
> --
> xpengiPosted from http://www.pcreview.co.uk/ newsgroup access
>


.

Relevant Pages

  • Re: JOIN on multiple conditions
    ... You must use the OUTER JOIN syntax, of course, ... >but if you learn only the INNER JOIN syntax does it change the way you ... More complicated queries should not be written by ... condition is placed in the ON or in the WHERE clause. ...
    (microsoft.public.sqlserver.programming)
  • Re: error -2147217904 - how to fix :o( ?
    ... If the saved queries don't have WHERE clauses, yes, the saved ... When I say on-the-fly SQL, ... use the base saved query and add a WHERE clause. ...
    (comp.databases.ms-access)
  • Re: how to use partitions once created?
    ... Your example queries worked perfectly. ... is a Where clause and a slice the same thing - semantically ... > Please do not send email directly to this alias. ...
    (microsoft.public.sqlserver.olap)
  • Re: problem getting a query to recognize "Not" and "<>" in a value list combo box
    ... When I think of queries, ... over for a while before I can really grasp it conceptually. ... The WHERE clause is just a Boolean algebra expression which evaluates to ... if I want to explicitly retrieve all records. ...
    (microsoft.public.access.forms)
  • Re: where clause
    ... embedded in queries, I suspect that depends on the nature of the queries, ... A concept that may help to understand is  to note that Jet evaluates the ... Move the VBA function to the WHERE clause, and now, ... use another query as source if previous query to limit recrods. ...
    (microsoft.public.access.queries)