combo to show list of tables

[Guest]

SELECT DISTINCT MSysObjects.Name FROM MSysObjects;

how if i want to get only tables? any help

 

[Jeff Conrad]

SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Rob Parker]

Add "WHERE Type = 1" to your SQL.

To exclude the system tables, use:

SELECT DISTINCT MSysObjects.Name FROM MSysObjects WHERE Name Not Like
"msys*" AND Type=1;

HTH,

Rob

 

[Guest]

thanks to both of you for respose and help . tested both and it is working
perfect.
thanks again.