Punya Account Blogger?
Posted by Sofyan SOX on Rabu, 09 Juni 2010 in

'1. Membersihkan Teks
Sub bersih()
 Text1 = "": DataCombo1 = "": Text2 = "": Text3 = "": Text4 = ""
End Sub

'2. Menonaktifkan teks
Sub nonaktif()
  Text1.Enabled = False: DataCombo1.Enabled = False: Text2.Enabled = False
  Text3.Enabled = False: Text4.Enabled = False: csimpan.Enabled = False
End Sub

'3. Mengaktifkan Teks
Sub aktif()
  DataCombo1.Enabled = True: Text1.Enabled = True: Text3.Enabled = True
End Sub



'4. Kondisi pada saat form dijalankan
Private Sub Form_Activate()
  bersih
  nonaktif
  cbaru.SetFocus
End Sub

'5. Mengaktifkan Teks (Kondisi Awal pengisian)
Private Sub cbaru_Click()
  bersih
  aktif
  Text1.SetFocus
  csimpan.Enabled = True
End Sub

'6. Mencari harga berdasarkan ukuran foto
Private Sub DataCombo1_Click(Area As Integer)
  Adoharga.Recordset.Find "ukuran='" + DataCombo1 + "'", , adSearchForward, 1
  If Not Adoharga.Recordset.EOF Then Text2.Text = Adoharga.Recordset!harga: Text3.SetFocus
End Sub

'7. Mencari ( Total Bayar = Jml * Harga )

Private Sub Text3_KeyPress(KeyAscii As Integer)
 If KeyAscii = 13 Then Text4.Text = Val(Text3) * Val(Text2): csimpan.SetFocus
End Sub


'8. Menyimpan data
Private Sub csimpan_Click()
  With AdoFoto.Recordset
    .AddNew: !nocetak = Text1: !ukuran = DataCombo1
    !harga = Text2: !jml = Text3: !bayar = Text4: .Update
  End With
    MsgBox "data Tersimpan": nonaktif: bersih: csimpan.Enabled = False
End Sub
0 Responses to “Foto Genik ( Adodc 2 tabel)”:

Posting Komentar