Re: [Programmer-VB] [Help] Query Tanggal di Acces - SOLVED

[Dedy]

thanx buat bung Ridwan atas sarannya ternyata harus pakai code seperti ini : rs.open "select * from tblA where tgl=#" & format(txtTgl.value,"mm-dd-yyyy") & "#" thanx ya M Ridwan Muslim wrote: 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] Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.