Dear All,
Rekan semua, saya lagi coba ni migrasi dari mdb ke adp,
saya lagi coba buat list di form yang menampilkan stored procedure dari
datbase northwind
scrippnya kayak gini..:
Private Sub btn1_Click()
Dim conn As ADODB.Connection
Set conn = CurrentProject.Connection
Dim cmb As New ADODB.Command
Dim rs As ADODB.Recordset
cmb.ActiveConnection = conn
cmb.CommandText = "[Ten Most Expensive Products]"
cmb.CommandType = adCmdStoredProc
Set rs = cmb.Execute
While Not rs.EOF
List2.AddItem rs.Fields(0)
rs.MoveNext
Wend
Set rs = Nothing
Set cmb = Nothing
Set conn = Nothing
End Sub
Salahnya dimana ya..?
mohon pencerahan, kalau ada referensi atau ebook about ADP info dong...!!!
Makasih ya sebelumnya...
salam
Rully, newbie banget...
Nikmati chatting lebih sering di blog dan situs web. Gunakan Wizard
Pembuat Pingbox Online. http://id.messenger.yahoo.com/pingbox/
