Coba pake tanda Kress (#) rs.open "select * from tblA where tgl= #" & txtTgl.value & "#"
Dedy wrote, On 8/22/2005 2:27 PM: > guys, > saya mo select data berdasarkan tanggal tertentu, > kenapa hasil yg di select dianggap tidak ada alias Null > saya pake code : > > dim rs as new recordset > rs.open "select * from tblA where tgl=" & txtTgl.value > if not rs.Eof then > A = nama > B = NoHP > end if > > database: > Nama NoHP Tgl > AAAA 0812123456 21-08-2005 > BBBB 0812045678 21-08-2005 > CCCC 0812000001 22-08-2005 > DDDD 0812888555 22-08-2005 > > > kalau tglnya saya pilih 22-08-2005 seharusnya datanya ketemu, tapi di > program tidak di ketemukan alias null, > saya juga dah coba buat baru databasenya, tetap ga bisa > saya juga dah coba langsung query id accessnya pakai: > select * from tblA where tgl ='21-08-2005' > saya run hasilnya null..., > formatnya juga dah saya ganti sama aja... > > dimana letak permasalahannya...? > > thanx > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > > > ------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > * Visit your group "Programmer-VB > <http://groups.yahoo.com/group/Programmer-VB>" on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------------------------------------------------ > -- Mohammad Ridwan Muslim ------------------------------- EDP/ Business System Department. PT. Samudera Indonesia Tbk. Div. Hapag-Lloyd Samudera Indonesia Building Lt. 8 Jl. Let. jen. S. Parman Kav.35 - Jakarta Barat 11480 Phone : +6221 5495225 EXT 19. Fax : +6221 5304181. Email : [EMAIL PROTECTED] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hn26mqg/M=362335.6886445.7839731.1510227/D=groups/S=1705115364:TM/Y=YAHOO/EXP=1124704455/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] 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/
