optain a list available forms

[Guest]

how can I optain a list of available form names. the form object would only
let me access open forms....................

 

[Douglas J. Steele]

Simplest way is to use the following SQL in a query:

SELECT [Name]
FROM MSysObjects
WHERE [Type]=-32768
ORDER BY [Name]

 

[Arvin Meyer [MVP]]

I use the code in the following demo database to fill a listbox with forms
or reports so that I can fix Microsoft's poor naming conventions:

http://www.datastrat.com/Download/FixNames2K.zip