Form to display list of fields

Hi everyone

I would like to have a VBA code for access in a form with a button. When it's clicked, I would like to have a new table that gives me a list of the fields in each of the Tables inside my DB. I am handling DB files with a lot of tables with a lot of fields.

Don't know if it's possible

Thank you!

paste code into module, then run: BuildAllDefTbls
you MUST load the REFERENCE: Microsoft Office XX.x Object Library

Please Login or Register  to view this content.