Maksud saya coba Pakai :
str = "{tbl_rawat. tanggal}> #" & Format(DTPicker1. Value,
"MM-DD-YYYY" ) & "# and {tbl_rawat.tanggal} < #" &
Format(DTPicker2. Value, "MM-DD-YYYY" ) & "# and {tbl_rawat.nip} = " &
cmbnn.Text
atau
str = "{tbl_rawat. tanggal}> #" & Format(DTPicker1. Value,
"MM-DD-YYYY" ) & "# and {tbl_rawat.tanggal} < #" &
Format(DTPicker2. Value, "MM-DD-YYYY" ) & "# and {tbl_rawat.nip} = '" &
cmbnn.Text & "'"
----- Pesan Asli ----
Dari: iwan gunawan <[EMAIL PROTECTED]>
Kepada: [EMAIL PROTECTED]; [email protected]
Terkirim: Senin, 7 Juli, 2008 17:00:10
Topik: [indoprog-vb] CR dgn 3 filter gmn?
Guys, gw bikin filter di Cr dgn periode dah bisa, ini codingnya :
str = "{tbl_rawat. tanggal}> #" & Format(DTPicker1. Value, "MM-DD-YYYY" ) & "#
and {tbl_rawat.tanggal} < #" & Format(DTPicker2. Value, "MM-DD-YYYY" ) &
"# "
nah kalo gw mo filter lagi berdasarkan nip gmn? gw dah coba tambah coding
kayak gini, tp ga bisa.
and {tbl_rawat.nip} #" & cmbnn.Text & "#"
bagi donk elmunya, thanks.
[Non-text portions of this message have been removed]
___________________________________________________________________________
Nama baru untuk Anda!
Dapatkan nama yang selalu Anda inginkan di domain baru @ymail dan @rocketmail.
Cepat sebelum diambil orang lain!
http://mail.promotions.yahoo.com/newdomains/id/
[Non-text portions of this message have been removed]
