alo mas iwan, udah coba pake cr1.sqlquery blm??
jd jgn pake cr1.selectionformula lagi..
kalo pake cr1.sqlquery jd prinsipnya sama kayak kita pake perintah select biasa 
mas..
semoga pengetahuan yang sederhana ini bisa membantu ya mas..
GBU

--- On Mon, 7/7/08, iwan gunawan <[EMAIL PROTECTED]> wrote:

From: iwan gunawan <[EMAIL PROTECTED]>
Subject: [indoprog-vb] CR dgn 3 filter gmn?
To: [EMAIL PROTECTED], [email protected]
Date: Monday, July 7, 2008, 5:00 AM






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]

 














      

[Non-text portions of this message have been removed]

Kirim email ke