统计代码行的源程序
时 间:2004-12-23 00:00:00
作 者:竹笛 ID:8 城市:上海 QQ:2851379730
摘 要:统计代码行的源程序
正 文:
当您有开发完一个作品时,也许你希望知道你的代码写了多少行,这时你可以使用下面的代码来统计它,不过有些耗时,我统计了一下我开发的一个软件,共8108行,运行了近20分钟:-D
在你的程序中新增一模块,命名为:mdlCountLines,并复制下面的代码到该模块中:
Public Function fCountLines() As Long
' Code to count the number of lines of code in the current database
On Error GoTo E_Handle
Dim db As Database
Dim ctr As Container
Dim doc As Document
Dim frm As Form
Dim rpt As Report
Dim mdl As Module
Dim lngCount As Long
Dim intCount As Integer, intLoop As Integer
Set db = CurrentDb
Set ctr = db.Containers!Forms
For Each doc In ctr.Documents
DoCmd.OpenForm doc.Name, acDesign, , , , acHidden
Set frm = Forms(doc.Name)
If frm.HasModule = True Then
Set mdl = frm.Module
intCount = mdl.CountOfLines
For intLoop = 1 To intCount
If Len(mdl.Lines(intLoop, 1)) > 0 And Left(Trim(mdl.Lines(intLoop, 1)), 1) <> "'" Then
lngCount = lngCount + 1
End If
Next intLoop
Set mdl = Nothing
End If
DoCmd.Close acForm, doc.Name
Set frm = Nothing
Next doc
Set ctr = db.Containers!Reports
For Each doc In ctr.Documents
DoCmd.OpenReport doc.Name, acViewDesign
Set rpt = Reports(doc.Name)
If rpt.HasModule = True Then
Set mdl = rpt.Module
intCount = mdl.CountOfLines
For intLoop = 1 To intCount
If Len(mdl.Lines(intLoop, 1)) > 0 And Left(Trim(mdl.Lines(intLoop, 1)), 1) <> "'" Then
lngCount = lngCount + 1
End If
Next intLoop
Set mdl = Nothing
End If
DoCmd.Close acReport, doc.Name
Set mdl = Nothing
End If
Next doc
fCountLines = lngCount
fExit:
On Error Resume Next
Set ctr = Nothing
Set db = Nothing
Exit Function
E_Handle:
MsgBox Err.Description & vbCrLf & "fCountLines", vbOKOnly + vbCritical, "Error: " & Err.Number
Resume fExit
End Function
Access软件网QQ交流群 (群号:483923997) Access源码网店
常见问答:
技术分类:
源码示例
- 【源码QQ群号19834647...(12.17)
- 【Access窗体导出PDF】...(04.08)
- 【Access窗体导出PDF】...(04.07)
- Access两种方式实现即时更...(03.01)
- Access隐藏与显示lacc...(01.12)
- 【Access高效办公】将每个...(12.23)
- Access21点游戏源代码(12.13)
- 【Access窗体导出Exce...(11.15)
- 【Access开发】Acces...(11.14)
- 通过Access宏录入数据到选...(11.10)
学习心得
最新文章
- 【Access表名称命名建议】将A...(04.20)
- Access学习笔记--用Acce...(04.19)
- 【Access重复项查询示例】将A...(04.17)
- Access快速开发平台企业版--...(04.16)
- 【Access模块示例】通过模块代...(04.15)
- Access查询里面分组合计功能添...(04.13)
- 【Access删除查询】删除数字最...(04.12)
- 显示文件夹中所有文件的修改时间(04.11)
- 铁路工程管理系统;铁路工程管理小程...(04.10)
- 【Access查询示例】怎么将两个...(04.09)