Private Sub F1_Click()
PRODUK.Show
End Sub
Private Sub F2_Click()
PELANGGAN.Show
End Sub
Private Sub F3_Click()
PENJUALAN.Show
End Sub
Private Sub MDIForm_Load()
End Sub
Private Sub mnC1_Click()
Form4.Show
End Sub
Private Sub mnC2_Click()
Form5.Show
End Sub
Private Sub mnc3_Click()
Form6.Show
End Sub
Minggu, 03 Juli 2011
LISTING PROGRAM YANG ADA DI FORM MENU
LISTING PROGRAM BUAT MODULE
MODULE
Public Db As New ADODB.Connection
Public RS As New ADODB.Recordset
Public RS2 As New ADODB.Recordset
Public SQL As String
Sub OPENDB()
If Db.State = adStateOpen Then Db.Close
Db.CursorLocation = adUseClient
Db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=tokoku"
End Sub
Sub ClearFORM(f As Form)
Dim ctl As Control
For Each ctl In f
If TypeOf ctl Is TextBox Then ctl.Text = ""
If TypeOf ctl Is ComboBox Then ctl.Text = ""
Next
End Sub
LISTING PROGRAM BUAT FORM PEDUKUNG CRISTALREPORT SETIAP FORM LISTING FROGRAMNYA SAMA SAJA 1 DGN YG LAIN JADI HANYA 1 SAJA YANG DIPOSTING PAK
FORM4
Dim Report As New CrystalReport2
Private Sub Form_Load()
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
End Sub
Private Sub Form_Resize()
CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth
End Sub
Sub Center(f As Form)
f.Move (Screen.Width - f.Width) / 2, (Screen.Height - f.Height) / 4
End Sub
Sub RubahCMD(f As Form, L0 As Boolean, L1 As Boolean, L2 As Boolean, L3 As Boolean)
f.cmdproses(0).Enabled = L0
f.cmdproses(1).Enabled = L1
f.cmdproses(2).Enabled = L2
f.cmdproses(3).Enabled = L3
End Sub
