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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grant - 07 Jun 2006 08:44 GMT

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.

Reply to this Message

Alex Dybenko - 07 Jun 2006 11:48 GMT

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

Signature

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

> Hi,
>
[quoted text clipped - 20 lines]
>
> Grant.

Reply to this Message