Saya coba di LogTime pada tblLogHistory dan FrmLogHistory dengan format dddd "," d mmmm yyyy hh:nn:ss AM/PM
Hasilnya Selasa, 16 Maret 2010 11:21:48 PM Sekedar info Thanks Masimam From: [email protected] [mailto:[email protected]] On Behalf Of Cecep W Sent: 15 Maret 2010 15:34 To: [email protected] Subject: Re: [belajar-access] Re: Ambil data untuk tabel sudah berhasil mas BO terimakasih banyak..... Regards CW Pada 15 Maret 2010 14:39, Belajar Office <[email protected]> menulis: Sdh betul Pak, memang ditempelkan di properties format pada field LogTime, aneh juga kalau tidak jalan, mungkin teman2 ada yg mengalami kasus serupa? Mohon sharing solusinya. Thank's ----- Original Message ----- From: "Cecep W" <[email protected]> To: <[email protected]> Sent: Monday, 15 March 2010 2:11 PM Subject: Re: Ambil data untuk tabel format ini di tempelkan dimana ya? saya sudah coba di properties Format LogTime pada FormLogHistory tapi ga bisa. maaf kalo pertanyaan saya ini terlalu mendasar. regards CW ----- Original Message ----- From: "Belajar Office" <[email protected]> To: [email protected] Date: 15 Maret 2010 13:49 Subject: Ambil data untuk tabel > > Mungkin bisa menggunakan fasilitas format "dd mmmm yyyy hh:nn:ss AM/PM" > Pak > > Thank's > ----- Original Message ----- > From: Cecep W > To: [email protected] > Sent: Monday, 15 March 2010 1:06 PM > Subject: Re: [belajar-access] Ambil data untuk tabel > > > > Okeh terimaksasih banyak, sudah sukses... > kalo supaya format [LogTime] 15 Maret 2010 13:15:20, gimana ya? > > Regards > CW > > 2010/3/15 MBA <[email protected]> > > Mungkin sbb: > > > DoCmd.RunSQL "INSERT INTO TblLogHistory ( [User], [LogTime], [Note] )" _ > & " SELECT '" & strUser & "' AS [User], Now() AS [Log Time], '" & > strPesan & "' AS [Note];" > > Salam, MBA > > > > ------------------------------------ SPAM IS PROHIBITEDYahoo! Groups Links
