Count line of codes

R

Rena

Hi all expert,
are there any ways to count for the total number line of codes written
within a *.mdb access file?

Thanks a lot.

Best Wishes,
Rena.
 
J

Jeff Conrad

in message:
Hi all expert,
are there any ways to count for the total number line of codes written
within a *.mdb access file?
Click to expand...

Hi Rena,

I created an Access Add-In called the "Albert Kallal Database Statistics"
that does exactly this. The add-in will make a one-page report that lists
the total number of lines of code in Modules, Forms, and Reports (a
sub total for each and a grand total) as well as a count of each other
type of database object (a sub total for each category and a grand total).

Once installed (takes less than a minute) all you have to do is
Tools | Add-Ins | Albert Kallal Database Statistics. Poof!
After a short time a slick report is displayed on the screen. Easy as pie!
A few words of warning though. This will have some INTENSE screen
flickering so you may want to look away from the monitor. Serious!

Remember the movie "Raiders of The Lost Ark" when they looked
into the Ark? Yeah......you heard me, best to look away!

Also, make sure you always have good backups of your file before
launching since it is intense code! Don't miss that step.

I am awaiting word back from Albert about the possibility of having him post
it on his web site where anyone can download it. In the meantime, I do not
believe he would have a problem if I sent you a copy. If you do wish to have
a copy please let me know where you would like it sent to (please mung the
e-mail address so you won't get spammed!). There is one version for Access
97 and one for 2000 which works with Access 2000, 2002, and 2003.
I will need to know which version you need.
 
P

Paul Overway

Jeff,

You might consider Application.Echo False while opening modules to get
CountOfLines. I haven't tried it, but that might cut down on all the
flickering.
 
J

Jeff Conrad

in message:
Jeff,

You might consider Application.Echo False while opening modules to get
CountOfLines. I haven't tried it, but that might cut down on all the
flickering.
Click to expand...

Humm....interesting idea Paul.
Thanks for the comment, I will have to try that out!
 
R

Rena

Hi Paul,
Thanks a lot for your suggestion :D

Paul Overway said:
Jeff,

You might consider Application.Echo False while opening modules to get
CountOfLines. I haven't tried it, but that might cut down on all the
flickering.
Click to expand...
 
J

Jeff Conrad

in message:
Hi Jeff
Thanks for your reply.
I afraid some of my old project need to be used too.
If it is possible would you mind sending both version to <snipped>
Click to expand...

Hi Rena,

Sure I can send you both copies.
Please review the Usage Guide (in Word) first as it details installation
and usage information. Please follow the important steps about
creating backups.

You may have trouble installing and running both versions at the same
time. The code and file names are totally identical so if you install
both I'm pretty sure Access will get confused. You may have to install
one version and then document the databases for that version. Following
that, you might have to uninstall, remove the existing file and then install
the other file. Could be cumbersome.

If you have a lot of difficulty with this, post back to the newsgroup
and I will modify the add-ins so you can install and run both versions
on the same machine.

Please post back here so I know you received the files.
 
R

Rena

Hi Jeff
I had received it. and just tested it Thanks a lot for your help :D

THX~!

Rena
 
J

Jeff Conrad

in message:
Hi Jeff
I had received it. and just tested it Thanks a lot for your help :D

THX~!
Click to expand...

Excellent, I'm glad you received the files and everything works fine Rena.
Thanks for checking back.

Good luck with your projects,
 
R

Rena

Thanks Jeff :D

Jeff Conrad said:
in message:


Excellent, I'm glad you received the files and everything works fine Rena.
Thanks for checking back.

Good luck with your projects,
Click to expand...
 
Top