[AccessD] How do I list all forms in an ADP (no MSysObjects)

Loop through the CurrentProject.AllForms collection.

Charlotte Foust

-----Original Message-----
From: David McAfee [mailto:DMcAfee at haascnc.com] 
Sent: Monday, March 31, 2003 5:41 PM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] How do I list all forms in an ADP (no MSysObjects)


In an Access 97 MDB, I can use the following SQL statement to list all
forms in an MDB:

SELECT MSysobjects.Name
FROM MSysobjects
WHERE (((MSysobjects.Type)= -32768))
ORDER BY MSysobjects.Name;

I know there are no local tables in an ADP, but somehow, somewhere,
Access must be keeping this information. Is there an equivalent way of
doing the same (either SQL or VBA) in an ADP?


TIA

David McAfee
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com