How to use VBA to List Microsoft® Access Database Objects
Last updated on 2020-05-26 by David Wallis.
If you viewed this page before its update on 2020-03-25, then all procedures for listing forms, modules, queries, reports and tables were on this one page. Since then, to give more space to those you’ll find each topic on its own page:
- List forms
- List modules — also as a procedure for listing all macros
- List queries
- List reports
- List tables — contains procedures for listing all table, tables excluding system tables, and only linked tbales.
Each function is for inclusion in any of your databases. You execute it in the Immediate Window of the database’s Visual Basic Editor where the function will produce the list.
Queries for Listing Database Objects
I'm writing pages on using queries to list database objects. You may find these a convenient alternatives to the my VBA funcetions.
Publication of these new pages may take a while, unless you contact me to let me know there’s interest right now.
Your Support for dmw TIPS
If you’re going to make use of Tips in any of your professional or commercial work, then please consider making a payment in recognition of the time spent publishing this website, keeping it free of advertising.
To make a contribution by PayPal in GBP (£ sterling) —
To make a contribution by PayPal in USD ($ US) —
To say how much you want to pay and to receive
a tax invoice for a GBP (£ sterling) contribution —
Thanks, in anticipation.
DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any techniques, methods or code included in this website are applied. Back up your data; test thoroughly before using on live data.