narrowing list of MsysObjects displayed

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I have a combo box that currently lists all tables in my
database so that they may be "selected" from. I would
like to restrict the list of tables to only those with a
particular naming scheme. (e.g.: list all tables with
names ending in the letters "ing".

Thanks in advance for your help.
CJ
 
CJ,

SELECT [Name]
FROM MSysObjects
WHERE [Type] = -32768 AND [Name] LIKE "*ing"

....or...

SELECT [Name]
FROM MSysObjects
WHERE [Type] = -32768 AND Right([Name], 3) = "ing"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top