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 > > > >
