1. Forum
  2. Usenet
  3. COMP.DATABASES.MS-ACCESS

  • Printing out a list of Modules?

    From Ron Weiner@21:1/5 to After serious thinking Peter Jason on Sat Aug 7 20:03:45 2021
    After serious thinking Peter Jason wrote :
    MSoft 365

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

    Can Access do this?

    P

    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Peter Jason@21:1/5 to All on Sun Aug 8 09:37:00 2021
    MSoft 365

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

    Can Access do this?

    P

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From orange@21:1/5 to All on Sat Aug 7 17:42:37 2021
    Do you mean module names, or do you want to list module lines?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Peter Jason@21:1/5 to All on Sun Aug 8 11:18:54 2021
    Thanks to all. I have since found what I want in MSoft365....

    Database Tools/Database Documenter /

    This lists, & can print them all.

    Regards, P

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)