📄 reportneraca.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Object = "{D18BBD1F-82BB-4385-BED3-E9D31A3E361E}#1.0#0"; "KewlButtonz.ocx"
Begin VB.Form frmReportNeraca
BackColor = &H00FBF7F4&
BorderStyle = 1 'Fixed Single
Caption = "Neraca"
ClientHeight = 7650
ClientLeft = 45
ClientTop = 330
ClientWidth = 11775
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Icon = "ReportNeraca.frx":0000
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 510
ScaleMode = 3 'Pixel
ScaleWidth = 785
ShowInTaskbar = 0 'False
StartUpPosition = 2 'CenterScreen
Begin KewlButtonz.KewlButtons btnClose
Height = 390
Left = 10275
TabIndex = 8
Top = 6900
Width = 1290
_ExtentX = 2275
_ExtentY = 688
BTYPE = 3
TX = "&Close"
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 15002603
BCOLO = 15002603
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "ReportNeraca.frx":0EBA
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin KewlButtonz.KewlButtons btnPrint
Height = 390
Left = 8925
TabIndex = 7
Top = 6900
Width = 1290
_ExtentX = 2275
_ExtentY = 688
BTYPE = 3
TX = "&Print"
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 15002603
BCOLO = 15002603
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "ReportNeraca.frx":0ED6
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin KewlButtonz.KewlButtons btnView
Height = 315
Left = 2025
TabIndex = 2
Top = 1050
Width = 1290
_ExtentX = 2275
_ExtentY = 556
BTYPE = 3
TX = "Vie&w"
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 15002603
BCOLO = 15002603
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "ReportNeraca.frx":0EF2
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Irfan.IrfanHeader ihdForm
Align = 1 'Align Top
Height = 825
Left = 0
Top = 0
Width = 11775
_ExtentX = 20770
_ExtentY = 1455
Text = "Neraca"
End
Begin MSComctlLib.ListView lvActiva
Height = 4890
Left = 225
TabIndex = 3
Top = 1500
Width = 5640
_ExtentX = 9948
_ExtentY = 8625
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 0
NumItems = 0
End
Begin MSComctlLib.ListView lvPassiva
Height = 4890
Left = 5925
TabIndex = 5
Top = 1500
Width = 5640
_ExtentX = 9948
_ExtentY = 8625
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 0
NumItems = 0
End
Begin MSComCtl2.DTPicker dtPeriode
Height = 315
Left = 825
TabIndex = 1
Top = 1050
Width = 1140
_ExtentX = 2011
_ExtentY = 556
_Version = 393216
CustomFormat = "yyyy-MM"
Format = 66781187
CurrentDate = 38982
End
Begin VB.Label lblTotal
Alignment = 1 'Right Justify
Appearance = 0 'Flat
BackColor = &H00F0E0D5&
BorderStyle = 1 'Fixed Single
Caption = "0"
BeginProperty Font
Name = "Verdana"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 315
Index = 1
Left = 9525
TabIndex = 6
Top = 6450
Width = 2040
End
Begin VB.Label lblTotal
Alignment = 1 'Right Justify
Appearance = 0 'Flat
BackColor = &H00F0E0D5&
BorderStyle = 1 'Fixed Single
Caption = "0"
BeginProperty Font
Name = "Verdana"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 315
Index = 0
Left = 3825
TabIndex = 4
Top = 6450
Width = 2040
End
Begin VB.Label lblForm
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Pe&r:"
Height = 195
Index = 0
Left = 225
TabIndex = 0
Top = 1095
Width = 360
End
End
Attribute VB_Name = "frmReportNeraca"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private lx As MSComctlLib.ListItem
Private Sub btnClose_Click()
Call Unload(Me)
End Sub
Private Sub btnPrint_Click()
Call ShowReport("Neraca", "Neraca")
End Sub
Private Sub btnView_Click()
btnView.Enabled = False
Call FillActivaSubItemTotal(CInt(dtPeriode.Year), CInt(dtPeriode.Month))
Call FillPassivaSubItemTotal(CInt(dtPeriode.Year), CInt(dtPeriode.Month))
Call CountActiva
Call CountPassiva
If ((CCur(lblTotal(0).Caption) = 0) And (CCur(lblTotal(1).Caption)) = 0) Then
btnPrint.Enabled = False
Else
btnPrint.Enabled = True
End If
btnView.Enabled = True
End Sub
Private Sub Form_Load()
dtPeriode.Value = Now
Call SetHeader
Call FillActiva
Call FillPassiva
End Sub
Private Sub SetHeader()
Call lvActiva.ColumnHeaders.Add(, , "Uraian", 245)
Call lvActiva.ColumnHeaders.Add(, , "Jumlah", 120, ListColumnAlignmentConstants.lvwColumnRight)
Call lvPassiva.ColumnHeaders.Add(, , "Uraian", 245)
Call lvPassiva.ColumnHeaders.Add(, , "Jumlah", 120, ListColumnAlignmentConstants.lvwColumnRight)
End Sub
Private Sub FillActiva()
On Error GoTo NoActiva
Dim i As Integer, nItem As String, nFCode As String
' ---------------------------------------------------------------------------------
Set lx = lvActiva.ListItems.Add(, , "AKTIVA LANCAR")
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
nItem = "Kas#Bank#Piutang Usaha#Piutang Pihak Istimewa#Persediaan#Pajak Dibayar Di Muka#Biaya Dibayar Di Muka"
nFCode = "11#12#13#14#15#16#17"
For i = 0 To 6
Set lx = lvActiva.ListItems.Add(, , String(2, Chr(32)) & IndexString(nItem, i, "#"))
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
Call AddSubItem(IndexString(nFCode, i, "#"), 2, lvActiva, "Group01")
Next i
Set lx = lvActiva.ListItems.Add(, , " Sub Total")
lx.Bold = True
lx.ForeColor = RGB(0, 0, 255)
lx.Tag = "Total01"
Call lx.ListSubItems.Add(, , "0")
lx.ListSubItems(1).Bold = True
lx.ListSubItems(1).ForeColor = RGB(0, 0, 255)
' ---------------------------------------------------------------------------------
Set lx = lvActiva.ListItems.Add(, , " "): Call lx.ListSubItems.Add(, , " ")
Set lx = lvActiva.ListItems.Add(, , "AKTIVA TIDAK LANCAR")
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
nItem = "Investasi"
nFCode = "21"
Set lx = lvActiva.ListItems.Add(, , String(2, Chr(32)) & IndexString(nItem, 0, "#"))
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
Call AddSubItem(IndexString(nFCode, 0, "#"), 2, lvActiva, "Group02")
' ---------------------------------------------------------------------------------
nItem = "Aktiva Tetap (Pemilikan Langsung)"
nFCode = "221"
Set lx = lvActiva.ListItems.Add(, , String(2, Chr(32)) & IndexString(nItem, 0, "#"))
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
Call AddSubItem(IndexString(nFCode, 0, "#"), 2, lvActiva, "Group03")
' ---------------------------------------------------------------------------------
nItem = "Akumulasi Penyusutan Aktiva Tetap"
nFCode = "222"
Set lx = lvActiva.ListItems.Add(, , String(2, Chr(32)) & IndexString(nItem, 0, "#"))
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
Call AddSubItem(IndexString(nFCode, 0, "#"), 2, lvActiva, "Group04")
Set lx = lvActiva.ListItems.Add(, , " Sub Total")
lx.Bold = True
lx.ForeColor = RGB(0, 0, 255)
lx.Tag = "Total04"
Call lx.ListSubItems.Add(, , "0")
lx.ListSubItems(1).Bold = True
lx.ListSubItems(1).ForeColor = RGB(0, 0, 255)
' ---------------------------------------------------------------------------------
Set lx = lvActiva.ListItems.Add(, , " "): Call lx.ListSubItems.Add(, , " ")
nItem = "Aktiva Tetap(Leasing)"
nFCode = "231"
Set lx = lvActiva.ListItems.Add(, , String(2, Chr(32)) & IndexString(nItem, 0, "#"))
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
Call AddSubItem(IndexString(nFCode, 0, "#"), 2, lvActiva, "Group05")
' ---------------------------------------------------------------------------------
nItem = "Akumulasi Penyusutan Aktiva Tetap"
nFCode = "232"
Set lx = lvActiva.ListItems.Add(, , String(2, Chr(32)) & IndexString(nItem, 0, "#"))
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
Call AddSubItem(IndexString(nFCode, 0, "#"), 2, lvActiva, "Group06")
Set lx = lvActiva.ListItems.Add(, , " Sub Total")
lx.Bold = True
lx.ForeColor = RGB(0, 0, 255)
lx.Tag = "Total06"
Call lx.ListSubItems.Add(, , "0")
lx.ListSubItems(1).Bold = True
lx.ListSubItems(1).ForeColor = RGB(0, 0, 255)
' ---------------------------------------------------------------------------------
Set lx = lvActiva.ListItems.Add(, , " "): Call lx.ListSubItems.Add(, , " ")
Set lx = lvActiva.ListItems.Add(, , "AKTIVA LAIN-LAIN")
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
nItem = "Aktiva Tidak Berwujud#Aktiva Lain-lain"
nFCode = "241#25"
For i = 0 To 1
Set lx = lvActiva.ListItems.Add(, , String(2, Chr(32)) & IndexString(nItem, i, "#"))
lx.Bold = True
Call lx.ListSubItems.Add(, , " ")
Call AddSubItem(IndexString(nFCode, i, "#"), 2, lvActiva, "Group07")
Next i
Set lx = lvActiva.ListItems.Add(, , " Sub Total")
lx.Bold = True
lx.ForeColor = RGB(0, 0, 255)
lx.Tag = "Total07"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -