Control Properties on Access forms via DAO
Jos,
Thanks for the hint. But the original poster needs to go through
Access 2 databases from an Access 97 database. Will the old version
code work without conversion in A97? Also, can you set references "on
the fly" as you loop through databases?
Dimitri
Quote:
> Hello Dimitri
> You can use form in an other database by setting a reference to that
> database. Keep in mind however that on all places where something like
> set dbs = currentdb or set dbs = dbengine(0)(0)
> occurs you must substitute this for
> set dbs = codeDB
> Greetings
> Jos
> >I think that Controls collection is only available when the form is
> >opened (either in design or normal view). Now the question is how to
> >open a form which is not in current database. I dunno. I guess you can
> >import each form into current db and open it - eek...
> >For what it's worth.
> >Dimitri
> >> I'm trying to loop through forms of a group of Access v2 databases using
> >> v97. I can see the forms via the containers collection and can get the
> >> names of the forms via documents, but not the controls and their
> >> properties. I've looked at the diagramatical DAO hierarchy and could
> >> not see controls. How can I access properties of controls on forms from
> >> other databases?
> >> -mario
