NoData Event

14 May

From:    “Sofyan Efendi” <opi@softhome.net>
Date:    Wed, 23 Aug 2006 14:18:45 +0700

Event NoData terjadi setelah Microsoft Access mem-format report saat hendak nge-print suatu report, namun ternyata data yang hendak di print tersebut tidak ada, atau dengan kata lain recordset tersebut kosong. Syntax:

Private Sub Report_NoData( Cancel As Integer)

Penjelasan:

– Cancel: Jika diset true, maka akan akan membatalkan proses print, sehingga report tidak akan ditampilkan.

Contoh:

Private Sub Report_NoData( Cancel As Integer)
MsgBox “The report has no data.” & _
chr(13) & “Printing is canceled. ” & _
chr(13) & “Check the data source for the ” & _
chr(13) & “report. Make sure you entered ” & _
chr(13) & “the correct criteria (for ” & _
chr(13) & “example, a valid range of ” & _
chr(13) & “dates),.” vbOKOnly + vbInformation
Cancel = True
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: