Terimakasih atas responnya,
setelah saya chek type combonya dropdown combo bukan
list, yg kedua kalau perintahnya saya potong2 dengan
cara ini :
> sql = "insert into namatable " & _
> "(" & _
> "field1," & _
> "field2," & _
> "field3" & _
> ") values ('" & _
> txtvalue1.text & "','" & _
> txtvalue2.text & "','" & _
> txtvalue3.text & _
> "')"
timbul error too many line continuous, mungkin karena
banyak fieldnya.
dibawah ini code pada saat load form untuk combonya
Dim ls_Rec As String
Dim rs_Rec As ADODB.Recordset
ls_Rec = cn
Set fcn_Con = New ADODB.connection
fcn_Con.Open ls_Rec
'Mengisi data posisi
Set rs_Rec = fcn_Con.Execute("select npp, nama
from t_pegawai")
If Not (rs_Rec.BOF And rs_Rec.EOF) Then
cbo_npp2.Clear
cbo_npp1.Clear
rs_Rec.MoveFirst
Do While Not rs_Rec.EOF
cbo_npp1.AddItem rs_Rec!npp & "-" &
Trim(rs_Rec!nama)
cbo_npp2.AddItem rs_Rec!npp & "-" &
Trim(rs_Rec!nama)
cbo_pemakai.AddItem rs_Rec!nama
cbo_peminta.AddItem rs_Rec!nama
cbo_mengetahui.AddItem rs_Rec!nama
rs_Rec.MoveNext
Loop
End If
mohon pencerahanya
salam'
mc
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
