MS ACCESS MAILING LIST: {Disarmed} Re: [belajar-access] auto update

Thursday, December 1, 2011

{Disarmed} Re: [belajar-access] auto update

Dear mas Johan Hung,

Buat event after update pada subform, pada textbox

- tgl_act
- activity
- act_result

sebagai berikut :

Option Compare Database
Option Explicit

Private Sub Act_result_AfterUpdate()
Forms!frmCustomer!last_act_result = Me.Act_result.Value
End Sub

Private Sub Activity_AfterUpdate()
Forms!frmCustomer!last_act = Me.Activity.Value
End Sub

Private Sub tgl_Act_AfterUpdate()
Forms!frmCustomer!last_act_date = Me.tgl_Act.Value
End Sub

Thank you | Terima Kasih | Matur Suksema

Sumiyanto

--- On Sun, 27/11/11, joeh2_007 <johan.hung@gmail.com> wrote:

From: joeh2_007 <johan.hung@gmail.com>
Subject: [belajar-access] auto update
To: belajar-access@yahoogroups.com
Received: Sunday, 27 November, 2011, 12:26 PM

dear Pakar access,

saya sedang membuat database untuk merecord activity customer, dimana untuk activity dari customer akan di masukkan kedalam table activitylog dgn table di bawah :

Table customer :
custID >>autonumber
nama >>text
tgl_Lahir >>date
Alamat >>text
last_act >>text
last_act_result >>text
last_act_date >>text

Table Activitylog :
Act_id >>autonumber
tgl_act >>date
custID >>number
activity >>text
act_result >>text

untuk tampilan di form saya masukkan activitylog sebagai subform dari form customer.
yang ingin saya tanyakan bagaimana caranya supaya setiap ada penambahan activity pada activitylog akan langsung terupdate last activity pada table customer pada kolom last_act, last_act_result

mohon pencerahannya

Thanks

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 15

Visit Your Group

SPAM IS PROHIBITED

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

if(window.yzq_d==null)window.yzq_d=new Object(); window.yzq_d['ukroI2KJiVU-']='&U=13cnsuum7%2fN%3dukroI2KJiVU-%2fC%3d493064.14543979.14562481.13298430%2fD%3dMKP1%2fB%3d6060255%2fV%3d1';