How to export form object and its controls

[tjglick]

1) I want to export the db form object, the form names, and the form controls into a "table" to audit especially the cmd controls to potentially add security (to block certain workgroups or users).



2) [option] I also want to see the code to export this data into an Excel or txt file. For a large database, the debug.print output may not be complete in the immediate window.


3) I found the code below (sample) to export all objects but it is too detailed, though useful. It would be useful to also export the above 1) for other objects (reports, macros, etc) for auditing purposes




Public Sub ExportDatabaseObjects()
On Error GoTo Err_ExportDatabaseObjects

Dim db As Database
'Dim db As DAO.Database
Dim td As TableDef
Dim d As Document
Dim c As Container
Dim i As Integer
Dim sExportLocation As String

Set db = CurrentDb()
etc...


Thanks
TG