Accessing form properties after DoCmd.openform (1 Viewer)

[tfurnivall]

I have a need to scan and analyze form properties - including controls - for an arbitrary form in an arbitrary database.

Getting to the database is fine, and I then scan MsysObjects, to locate and identify the forms. This is where the trouble begins - if the form were being loaded from within the database itself, then it would be easy - the form would have a presence as an object, and I can then visit the controls collection and take it from there. However, DoCmd.OpenForm does not seem to create an object anywhere (if so, I can't find the documentation for it), and thus I can't get at the controls collection.

Has anybody done this (I know at least one person has, in the Access Analyzer, but it's remarkably reticent on form control information, hence my own inquiry)

Any help, pointers, suggestions gratefully appreciated!

Tony

 

[spikepl]

http://msdn.microsoft.com/en-us/library/office/ff822456.aspx

 

[tfurnivall]

Thanks for the pointer, Spike.

I haven't yet had a chance to see if a database opened other than as CurrentProject can have the AllForms (or indeed the AllAnything which sound delightfully useful ;-) object. However, it's a good start.

Tony