Skip to content

Module: Form_Monthly Billings

Type: Form
Lines of Code: 203
Source: ms_access_files\garnet\Forms\Frm Monthly Billings.txt

Dependencies

Module Dependencies: - Actdatabase - BillRecSet - RecSet

Tables Accessed: - Temp - RecSet

Forms Referenced: - Frm

External References: - Excel.Application

Procedures

UpdateNumber

Type: Public Sub
Lines: 20

Calls: UpdateNumber, OpenRecordset

DeleteRecs_Click

Type: Private Sub
Lines: 19

Calls: DeleteRecs_Click, Column, Selected

CloseFOrm_Click

Type: Private Sub
Lines: 13

Calls: CloseFOrm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

ExportMonthlyBillings_Click

Type: Private Sub
Lines: 86

Calls: Cells, OpenRecordset, Columns, ExportMonthlyBillings_Click, Worksheets, CreateObject, Fields

Form_Close

Type: Private Sub
Lines: 5

Calls: IsLoaded, Form_Close

Form_Open

Type: Private Sub
Lines: 3
Parameters: Cancel As Integer

Calls: Form_Open

GenerateMonthlyBillings_Click

Type: Private Sub
Lines: 45

Calls: Fields, OpenRecordset, GenerateMonthlyBillings_Click

Complexity Notes: - ⚠️ Contains GoTo statements