BeforeInsert Event

15 May

From:    “Sofyan Efendi” <sofyan@madinah.cc>
Date:    Wed, 16 Aug 2006 08:13:40 +0700

Event BeforeInsert terjadi saat user mengetikkan karakter pertama di dalam record baru, tetapi sebelum record tersebut terbuat secara sempurna.Syntax:

Private Sub Form_BeforeInsert( Cancel As Integer)

Penjelasan:

– Cancel : Jika diset True (-1), maka akan meng-cancel event BeforeInsert.

BeforeInsert dan AfterInsert merupakan dua event yang berpasangan. Urutan event tersebut adalah:

BeforeInsert -> BeforeUpdate -> AfterUpdate -> AfterInsert.

Contoh:

Private Sub Form_BeforeInsert( Cancel As Integer)
If MsgBox(“Insert new record here?”, _
vbOKCancel) = vbCancel Then
Cancel = True
End If
End Sub

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
– AccessWeb <http://www35.websamba.com/accessweb&gt;
– OPI-Homepage <http://www.geocities.com/opi1978&gt;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: