Here's code I use in the rowsource of a listbox to display queries/table names.
WHERE Type IN (1,5)
AND Name NOT LIKE 'MSys*'
Copy and paste this into the query (you may have to tweak the syntax from copying.)
You can modify the In(1,5) to decipher queries/tables.
You can also look at the properties in the MSysObjects table (you'll need to show all hidden/system tables)
Perhaps you can get what you need from that.
Otherwise, maybe the Creation Date (change view to see details) or some other can get you the info you need. You're a little vague on "getting the queries remotely or entered in the query window". I don't know what you mean by this.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)