How to use VBA to List All Forms in
Microsoft® Access Databases
How to create a VBA function to use in its Visual Basic Editor’s Immediate Window to list all the forms in your current Access database.
Last updated on 2020-05-26 by David Wallis.
VBA Function to List All Forms
This function lists all the forms in the database in which you execute it:
Function dmwListAllForms() As String
On Error GoTo errHandler
Dim frm As AccessObject, dB As Object
Set dB = Application.CurrentProject
For Each frm In db.AllForms
msg$ = "Forms listing complete"
dmwListAllForms = msg$
msg$ = Err.Number & " " & Err.Description
How to Run Your Function
To execute the function, copy and paste the above code into a module in your database’s Visual Basic Editor.
Then in its Immediate Window type ?dmwListAllForms and press Enter. The leading question mark is essential.
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.