Get List of Control/Properties of Form from another Access DB

[Guest]

Hi,

I am programming in VBA and using DAO to connect to another Access DB
(working fine).

What I am trying to do is get a list of the Controls and the Properties for
those controls for a Form on the other Access DB.

I can get a list of the Forms via the SysObjects, but can't seem to find a
way to access the Controls/Properties.

I have approx 850 Access Databases to check through (Lab Test with 850
students) so want to check their DB and see if they have created the Form
(ok), then check to see what Controls they have and what they have set for
the Properties.

I really want to use DAO (not ADO) but anything will do at this stage.

Thanks in advance.

Kind Regards,

Grant.

 

[Alex Dybenko]

hi,
using DAO you can get a list of forms, but in order to get
controls/properties - you have to use automation - open new Access instance
using CreateObject(), open target DB there, open certain form there and then
loop through its controls

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com