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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-access/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
