DB code and objects

[GraeagleBill]

Albert Kallal created a DB years ago for A97 that counted all the lines of code in a DB plus reporting the number of objects, modules, forms, queries, etc.. Has anyone created a more current version of that functionality? Colin has an object listing app and I see lines of code counters on the net, but not an app that does the whole job like Albert's did. While I still have a copy of Albert's old mdb, A2013 won't open it wherein perhaps it could be updated.

[Micron]

Not me, but object count seems easy enough if you have to roll your own:
https://www.devhut.net/count-of-the-...cess-database/

http://allenbrowne.com/vba-CountLines.html

[GraeagleBill]

Yes, I did see Allen's LOC counter.
DevHut link looks promising, but not the line "Currentproject.AllModules.Count 'does not include object modules". In my case, the preponderance of my forms and reports have modules so I can simply report accordingly.

[Micron]

What is the poster's definition of "object modules", custom classes? Anyway, the documentation I found makes no mention of this.

https://learn.microsoft.com/en-us/of...ess.allmodules

I guess the thing to do would be to test and compare the count with what you have.

[GraeagleBill]

I ran a combination of the what the Devhut posted plus Allen's code:
18,358 total LOC All modules (general, class and forms/reports)
52 tables
144 queries
64 forms
28 reports
75 general modules

Everything comes out in the IW. Maybe if I can find some time to play, I'll create a little app similar to what Colin likes to do and post it.

[isladogs]

You didn't provide details/links so I'm not sure what Albert's code did that mine doesn't: Database Statistics (isladogs.co.uk)



If you're eagle eyed you may spot an issue in the above screenshot....which I intend to fix at some point

I recently did a modified version for a different article: Access Specification issues (isladogs.co.uk)
That includes code to create a count of all code modules:



I would be VERY surprised if you really have 18,358 code modules as the 5450 figure was the limit I reached in testing (A365 32-bit). Possibly different in 64-bit Access. YMMV

You may have 18358 modules, forms & reports but many of those forms & reports will, I expect, have no code module

[GraeagleBill]

I just posted what Allen posted in the IW. The summary lines:
7108 line(s) in 76 stand-alone module(s)
10094 line(s) in 64 module(s) behind forms
1311 line(s) in 26 module(s) behind reports
18513 line(s) in 166 module(s)

I will download your app later this aftrnoon and run a comparison.

[isladogs]

18000+ code lines. Not code modules.
What is IW?

[GraeagleBill]

Sorry, Allen writes the stats to the Immediate Window.

Your module reveals similar stats: