Hi Everyone!
A pleasant day!
I have two listboxes in my Form one would display all my Tables and the other will display all my Queries.
I have tried Using the SQL in my Row Source as :
TABLES_LIST : RowSource = SELECT [Name] FROM MSysObjects WHERE [Type]=1 AND [Name] Not Like "~MSysACEs*" ORDER BY [Name];
QRY_LIST : SELECT [Name] FROM MSysObjects WHERE [Type]=5 AND [Name] NOT LIKE "~sq_*" ORDER BY [Name];
The problem are it would still display like below;
MSysAccessStorage
MSysAccessXML
......
Is there a way of getting red of this?
Please any kind of help is much appreciated.
Thanks in advance,
Rev12