Get Gifs at CodemySpace.com

Mengenai Saya

Foto saya
seorang mahasiswa dr budi darma

Minggu, 03 Juli 2011

LISTING PROGRAM YANG ADA DI FORM MENU

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

[+/-] Selengkapnya...

TAMPILAN FORM MENU




[+/-] Selengkapnya...

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

[+/-] Selengkapnya...

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

[+/-] Selengkapnya...

FORM PENDUKUNG BUAT CRISTALREPORT PRODUK, PELANGGAN, PENJUALAN



[+/-] Selengkapnya...

LAPORAN PRODUK, PELANGGAN, DAN PENJUALAN DENGAN CRISTAL REPORT



[+/-] Selengkapnya...

FORM PRODUK, PELANGGAN, PENJUALAN


[+/-] Selengkapnya...