Dear Mas Eris.
Saya rasa mungkin kurang teliti saja, filternya berdasarkan "(dtpicker1)" tapi
di query-nya pake "DTPicker2", mas eris pake berapa dtpicker ? kalo lebih dari
satu coba lihat masing-masing name properties-nya, sudah sesuai belum ?
Salam
"Eris Kadarisman" <[EMAIL PROTECTED]> on 04/12/2007 04:17:25 AM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: "lilis" <[EMAIL PROTECTED]> (bcc: Toni Rahayu/IT/domino_srv)
Subject: [Programmer-VB]
Dear All,
Mohon bantuannya, bener ngak code seperti ini
Mau mindahin data di filter berdasarkan tanggal (dtpicker.1) dari tabel1 ke
tabel2
Private Sub Command1_Click()
Dim sql As String
sql = "select * from tabel where DATE = '" & DTPicker2.Value & "'"
'MsgBox("Yakin mau ditransfer?", vbQuestion + vbYesNo, "") = vbYes
Data2.Recordset.AddNew
Data2.Recordset.Fields("DATE") = Data1.Recordset.Fields("DATE")
Data2.Recordset.Fields("STYLE") =
Data1.Recordset.Fields("STYLE")
Data2.Recordset.Fields("RECEIVING") =
Data1.Recordset.Fields("RECEIVING")
dst
Data2.Recordset.Update
Data2.Refresh
End Sub
saya coba tapi pindahnya tidak terfilter
Salam,
Eris (Pemula)
Toni Rahayu
PT. Omedata Electronics
IT Department
Hunting : (62-22) 6030805 Ext 121
Faxs : (62-22) 6030896
Homepage : http://toni.rahayu.tripod.com
