Oleh: buaton | Juni 13, 2009

Praktek 1

Dim Mydb As ADODB.Connection Dim TBiodata As New ADODB.Recordset Private Sub Command1_Click() CR.WindowState = crptMaximized CR.SelectionFormula = “{registeri.no_pin_peg} = ‘” & Me.xnama.Text & “‘” CR.Action = 1 End Sub Private Sub Command2_Click() Unload Me End Sub Private Sub Form_Load() Set Mydb = New ADODB.Connection Set registeri = New ADODB.Recordset Mydb.Open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & App.Path & “\dataku.mdb;Persist Security Info=False” Perintah = “Select * from registeri Order By no_pin_peg” registeri.Open Perintah, Mydb, adOpenDynamic, adLockOptimistic If Not registeri.EOF Then With registeri .MoveFirst While Not .EOF Me.xnama.AddItem registeri!no_pin_peg .MoveNext Wend End With End If End Sub


Tinggalkan Balasan

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Ubah )

Twitter picture

You are commenting using your Twitter account. Log Out / Ubah )

Facebook photo

You are commenting using your Facebook account. Log Out / Ubah )

Connecting to %s

Kategori

Ikuti

Get every new post delivered to your Inbox.