Hi,
I have a piece of code that lets me use one database, MyDB1, to look at a second database, MyDB2, and then allows me to get various field properties such as field type, validation rule, validation text, etc. What I do is:
Set db = DAO.DBEngine(0).OpenDatabase(".......\MyDB2.mdb")
Set tdf = db.TableDefs("Table1")
For Each fld In tdf.Fields
I ask for the info I need in this loop.
Next
It all works well and I would like to be able to do something similar for forms whereby I can use MyDB1 to get information for each control on a form such as control name, control source, etc. I can do this all within MyDB2 if I manulally open the form but what I really want to do is do it all from MyDB1.
The reason why I want to work this way is to develop a documentation database that I can use for all my databases.
Any help would be much appreciated.
Thanks.
I have a piece of code that lets me use one database, MyDB1, to look at a second database, MyDB2, and then allows me to get various field properties such as field type, validation rule, validation text, etc. What I do is:
Set db = DAO.DBEngine(0).OpenDatabase(".......\MyDB2.mdb")
Set tdf = db.TableDefs("Table1")
For Each fld In tdf.Fields
I ask for the info I need in this loop.
Next
It all works well and I would like to be able to do something similar for forms whereby I can use MyDB1 to get information for each control on a form such as control name, control source, etc. I can do this all within MyDB2 if I manulally open the form but what I really want to do is do it all from MyDB1.
The reason why I want to work this way is to develop a documentation database that I can use for all my databases.
Any help would be much appreciated.
Thanks.
