Mantap Pak MBA, dan udah bisa tuh kang Cecep saya coba di sini,
DoCmd.RunSQL "INSERT INTO TblLogHistory ( [User], [LogTime], [Note] )" _ & " SELECT '" & strUser & "' AS [User], Now() AS [Log Time], '" & _ strPesan & "' AS [Note];" ________________________________ From: MBA <[email protected]> To: [email protected] Sent: Mon, March 15, 2010 12:04:47 PM Subject: RE: [belajar-access] Ambil data untuk tabel Mungkin sbb: DoCmd.RunSQL "INSERT INTO TblLogHistory ( [User], [LogTime], [Note] )" _ & " SELECT '" & strUser & "' AS [User], Now() AS [Log Time], '" & strPesan & "' AS [Note];" Salam, MBA
