List Box

[Guest]

I have alist box that i would like to remove some of the table shown
in the Row source i have the following Statement
I will guess i need to add a NOT IN [NAME] some where.

SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<> "~"ORDER
BY [NAME]

Octet

 

[Douglas J. Steele]

That's correct.

 

[Guest]

Wher in the string would the NOT IN be placed?

That's correct.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have alist box that i would like to remove some of the table shown
in the Row source i have the following Statement
I will guess i need to add a NOT IN [NAME] some where.

SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<>
"~"ORDER
BY [NAME]

Octet

 

[Guest]

I Tried this
ELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<> "~" NOT
IN [NAME] (MakeTable),ORDER BY [NAME]
But it doesnt work

Wher in the string would the NOT IN be placed?

That's correct.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have alist box that i would like to remove some of the table shown
in the Row source i have the following Statement
I will guess i need to add a NOT IN [NAME] some where.

SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<>
"~"ORDER
BY [NAME]

Octet

 

[Douglas J. Steele]

Assuming that you're trying to eliminate a table named MakeTable, you'd use

SELECT [Name]
FROM MSysObjects
WHERE [Type]=5
AND Left ([Name],1)<> "~"
AND [Name] <> "MakeTable"
ORDER BY [NAME]

If you were trying to eliminate multiple tables, you'd use

SELECT [Name]
FROM MSysObjects
WHERE [Type]=5
AND Left ([Name],1)<> "~"
AND [Name] NOT IN ("MakeTable", "Table1", "Table2")
ORDER BY [NAME]



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I Tried this
ELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<> "~" NOT
IN [NAME] (MakeTable),ORDER BY [NAME]
But it doesnt work

Wher in the string would the NOT IN be placed?

That's correct.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have alist box that i would like to remove some of the table shown
in the Row source i have the following Statement
I will guess i need to add a NOT IN [NAME] some where.

SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<>
"~"ORDER
BY [NAME]

Octet

 

[Guest]

Works great thanks

Assuming that you're trying to eliminate a table named MakeTable, you'd use

SELECT [Name]
FROM MSysObjects
WHERE [Type]=5
AND Left ([Name],1)<> "~"
AND [Name] <> "MakeTable"
ORDER BY [NAME]

If you were trying to eliminate multiple tables, you'd use

SELECT [Name]
FROM MSysObjects
WHERE [Type]=5
AND Left ([Name],1)<> "~"
AND [Name] NOT IN ("MakeTable", "Table1", "Table2")
ORDER BY [NAME]



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I Tried this
ELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<> "~" NOT
IN [NAME] (MakeTable),ORDER BY [NAME]
But it doesnt work

Wher in the string would the NOT IN be placed?

:

That's correct.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have alist box that i would like to remove some of the table shown
in the Row source i have the following Statement
I will guess i need to add a NOT IN [NAME] some where.

SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left ([Name],1)<>
"~"ORDER
BY [NAME]

Octet