Printing out a list of Modules?

13 views
Skip to first unread message

Peter Jason

unread,
Aug 7, 2021, 7:37:11 PMAug 7
to
MSoft 365

I need to compare all current Modules with those of a past backup.

Can Access do this?

P

Ron Weiner

unread,
Aug 7, 2021, 8:03:51 PMAug 7
to
After serious thinking Peter Jason wrote :
Here is some code to list all of the modules in the current Database.
I havent got MSoft 365 to test with, but works fine in the older non
cloud versions.

Dim mod As Variant

For Each mod In CurrentProject.AllModules
Debug.Print mod.Name
Next

You could create a Table and insert the names one at a time in there,
and then slice and dice anyway you like.

Rdub

orange

unread,
Aug 7, 2021, 8:42:40 PMAug 7
to
Do you mean module names, or do you want to list module lines?

Peter Jason

unread,
Aug 7, 2021, 9:19:01 PMAug 7
to
Thanks to all. I have since found what I want in MSoft365....

Database Tools/Database Documenter /

This lists, & can print them all.

Regards, P
Reply all
Reply to author
Forward
0 new messages