Using MSysObjects in Queries

[DOLL]

Hola senor y senora.
I'm new here.
I am currently working on MS Access Project and I needed help from you guys. I have done smoothly so far, but now I'm stuck at this query:

SELECT [MSysObjects].[Name] AS ObjectName
FROM MSysObjects
WHERE (((IIF(Left([Name],4)="mis_",[Name],""))<>""))
GROUP BY [MSysObjects].[Name],Left([Name],4),[MSysObjects].[Type]
HAVING (((Left([Name],4))<>"MSys")
AND ((MSysObjects.Type)=1))
OR (((MSysObjects.Type)=-32768))
ORDER BY [MSysObjects].[Name];


Previously, there was somebody doing this project, and so I have to sort of enhance this project by moving a few buttons here and there. That query lists out all the tables that had been filtered. So, I am stuck now on what does the query actually means. I also had tried the query by creating a fake Query and type out the SQL but I still cannot understand how am I to go about re-using the query. Do hope anyone of you could help me out and explain to me. (Pardon me if I really sound ignorant. )

 

[raskew]

If you're looking for assistance in this, or any other, forum you might consider getting rid of your ugly little tag line. If you don't understand what you're saying, get an English-speaking acquaintance to translate for you.

Bob

 

[DOLL]

Sorry. I have already changed the line to something else. *smile* Hope you don't mind about that.

 

[Pat Hartman]

Here's a link to a post that contains some of the object type definitions. Since the tables are not documented, I can't be sure the list is definitive.

http://www.access-programmers.co.uk/forums/showthread.php?t=21922&highlight=MSysObjects

 

[raskew]

Pat -

That link doesn't seem to connect. Would you please test it.

Thanks, Bob

 

[Pat Hartman]

Sorry Bob, it works for me.